Oracle Sql
Resume:
Alpharetta, GA *****
JYOTI SHARMA Email:
***************@*****.***
Objective
A position that would allow me to utilize my expertise, in an environment
that encourages on-going skills development and growth.
Professional Summary
. 9+ years of Oracle Applications experience in Purchasing, INV, OE/OM,
iPay, ALERTS, AOL, iExpense, Fixed Asset, SYSADMIN,AME, AR, AP, GL
modules of Oracle Applications.
. Hands on involvement in business requirement, solution design,setup,workaround, interfaces and user training .
. Developed functional and technical documents as well as test plans and
test scenario using AIM methodology.
. Experience in Procure to Pay and Order to Cash business process flow.
. Experience in RICE customization of Oracle Application
11.5.10.0/11.5.10.2 and R12 in modules AR, AP,OM and implementation
of PO and ipay modules.
. Experience in database programming using Oracle 9i/10g/11g databases.
. Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers,
Views and Indexes.
. Experience in various development tools like SQL Developer,
SQL*Loader, Oracle Workflow 2.6, Forms 10g/6i, Reports 10g/6i, XML
Publisher.
. Experience in developing UNIX Shell scripts for loading data into
staging tables.
. Experience in Tuning SQL statements to improve execution performance
using TKPROF, SQL Trace, etc.
. Ability to learn and adapt to new technologies, good team player in
dynamic work group environments and also self motivated to work
independently with excellent communication skills.
Technical Skills
Oracle Apps: R12 (12.1.3), 11i (11.5.10.0/11.5.10.2),Oracle
Purchasing, AME, Oracle Financials (General Ledger, Account Payables,
Account Receivables), Order Management,Inventory, iPayment, Sys Admin,
Fixed Asset and AOL.
Oracle Tools: XML Publisher, Reports 10g/6i, SQL*Loader, Forms
10g/6i, Toad.
Database: Oracle 11g/10g/9i.
Languages: SQL, PL/SQL,XML
Operating Systems: SUN SOLARIS, HP-UNIX.
Scripting : PHP
Professional Experience
Purchasing Power LLC, Atlanta, GA Sept 2011 to
Till Date
Purchasing Power is a retail company, providing employee
purchase program through Payroll deduction Program.
o R12 Upgrade Project : This project involved upgrade from
existing 11.5.10 to 12.1.3, as part of this project
upgraded objects and processes in AR, AP, OM and PO.
. Converted Order Processor to import orders from e-
commerce and modified to implement new revenue
recognition process, Cash Application Process, AP
invoice load and PO creation using Open Interface .
. Created Custom Remittance Advice using XML Publisher
reports in AP.
. Develop Open Purchase Orders report using XML that
queries all Open PO's at header, line and shipment
levels and shows the quantity of goods received and
balance quantity of goods to be received against the
shipment line.
. Created custom program to create vendor for given
customer.
. Develop Account Analysis report that shows current
A/R balance, credit limit and past 12 months
transaction history for the customer(s) defined in
TCA. This report is being used by risk department in
order to analyze the customer history.
. Upgraded custom forms.
.
o Cancellation Process: This project involved streamlining
the company return process,which spanned across OM, PO and
AP modules of application.
. Used OM, PO cancellation API.
. Receiving Interface to "Return to Supplier"
. AP package to Un-attach Po and reverse invoice line.
o Developed pl/sql package to create Purchase order using
Open Interface for all the drop ship orders .
o Developed PL/SQL Packages, Procedures, Functions for
validating the shipping invoice from the file and imported
into Oracle Applications using the Payables Open Interface
Import program and populated the base tables, which
involved in Releasing Invoices from Hold.
o Developed pl/sql program to create AR credit memos.
o Created process to synchronize oracle inventory with
provided vendor quantity.
Technical Environment: Oracle Apps R12 (AR, PO, AP), XML Publisher,
Oracle 11g, Oracle Forms 10g, Oracle Reports 10g, PL/SQL, SQL Loader.
SouthernLINC Wireless, Atlanta, GA March 2008 to
Sept 2011
Senior Application Analyst
SouthernLINC Wireless is a Telecom company, pioneering in
providing Push-To-Talk, providing services to the utility and
government sector.
Responsibilities: Involved in functional and technical gap
analysis, created functional (MD050) and technical documents
(MD070), responsible for providing functional and technical post
production support, handled System Administration functions,
involved extensively in System Integration Testing, UAT before
production move and as part of technical deliverables created
pl/sql packages, workflow, personalized/customized forms, created
reports,defined AOL objects.
o Procure To Pay Implementation: This project involved
implementing Procure to Pay cycle for expense and capital
inventory items. It also involved interfacing capital item
to FA.
. Performed Functional Setup in Purchasing, Inventory
and Payables modules.
. Customized and defined the rules for PO Approval
workflow around approval hierarchy.
. Implemented AME for Payables Invoice Approval and
headed AP Initiative with Purchasing.
. Customized pl/sql package to customize PO number
sequence, and created pl/sql package to update
accounting distribution.
. Modified PO report and created various custom
reports.
. Customized Requisition form.
. Personalized Receiving and PO form.
. Lead UAT & Production Deployment.
o OM- E Comm Integration : Integrated iPayment module to
accept credit card order from Order Management, Oracle HTML
Quoting and external e-commerce system.
. Interfaced external e-commerce order to OM using
Oracle Seeded API.
. Integrated iPayment to BEP.
. Defined Order Type, Payment Method, Receipt Class,
Receivables Activity and set up Automatic Receipt and
Remittance creation process.
. Created pl/sql packages to update different receipt
method depending on credit card type.
o Write-Off (Financial -AR) : Involved clubbing of multiple
open Invoices / customer and creating one Write-Off CM per
customer, in this process all the revenue lines where
accounted under bad debt account and all the tax lines
where reversed to original account. CM was pro-rated if
their where any partial payments made and adjusted
accordingly if any adjustment was applied (line or tax).
. Create package to assign collectors to costumers,
customer percentage share and collector fee was
derived from DFF setup in Collector screen.
. Created Concurrent program (pl/sql package) to create
CM and apply to open invoices, also developed custom
reports using XML publisher.
o Lockbox Process (Financial -AR) : Set up Lockbox Processes
to import Payment from bank, defined and setup file
format, Receipt Source, Lockboxes and Transmission format.
. Developed sql loader control file and pl/sql package
to load and validate payment data.
o Employee Expense Payout (Financial -AP): Involved paying
employees expense using Direct Deposit.
. Migrated employee details from legacy system and
created supplier using API.
. Created Bank payment files using XML Publisher.
. Overall Status Reporting, Issue Resolution and
handling of escalations.
o E911 (Financial -AP): Involved remitting charges to the
state for availing 911 facility, payment was calculated on
the number of subscribers per state.
. Mapped Supplier to the geo-code on the commtax
report.
. Interfaced, validated and created invoices.
. Defined Source, Payment Term, Paygroup, DFF on
Invoice Distribution.
o FA - CATS (Financial -FA): Involved synchronizing assets
location in CATS with FA location.
. Mapped asset location and expense distribution based
on the CATS location using API.
. Created Exception report for retired, suspended and
fully retired assets.
o FA - Use Tax (Capital Item Tax): Creates Use Tax Journal
Entries and uploads to FA.
. Customized "Create Use Tax" to pass asset and
invoice distribution info.
. Processed Use Tax Journal entries in GL and created
Use Tax Addition entry in FA, which created post
addition line.
. Defined Value Set, DFF.
o Generated ad-hoc queries to analyze underlying data for
inconsistencies and integrity issues to find data issues.
o CU2 Upgrade: Team Lead for CU2 Upgrade team and functional
and technical lead for AR, iPay, Purchasing and OM modules.
. Training: R12.x Oracle Financial Applications Overview
Technical Environment: Oracle Apps 11.5.10.0/11.5.10.2 (AR, Oracle Alert,
iPayment, AP, GL, Inventory, FA, Purchasing), XML Publisher, OAF, Oracle
9i, Oracle Forms 6i, Oracle Reports 6i, PL/SQL, SQL Loader, TOAD.
DS Waters -- Atlanta, GA July 2007 to
March 2008
Responsibilities: Involved in R12 Upgrade project as technical team
member, created technical documents, responsible for providing
technical post production support, involved extensively in System
Integration Testing, UAT before production move and as part of
technical deliverables created pl/sql packages, workflow,
personalized/customized forms, created reports,defined AOL
objects
. R12 Implementation: Technical Team Member for R12 migration
project worked extensively in AP, AR and Purchasing modules.
Involved in defining accounting rule in SLA, analyzed and
responsible for upgrading custom code for AR, AP and PO modules.
o Interface: Created Interface to AP and AR modules.
o Customized Oracle Seeded Workflow (i.e. iExpense & PO
Approval) to implement Company Business Logic (i.e. Level
of Approval, Third Party Expense Approval, Timeout Feature)
o Created PL/SQL packages and respective Concurrent Programs
for:
. Creating JTF NOTE for Customer Merge Process in E
Business Center.
. Customer Specific Price Increase based on specific
customer criteria.
. Web_Util file of Customer Extract for SQL Server.
o Created Ad-Hoc reports and Customized Oracle and PL/SQL
reports in various oracle modules i.e. AR, AP, Pricing and
Route Management.
. Additional Responsibilities included fine Tuning, Creation of
Design Document (MD070), Third Level Customer Support and
coordinating with DBA for Production move.
Technical Environment: Oracle Apps R12 (SLA,AR, AP, PO), 11i,Oracle 10g,
Oracle Forms 10g/6i, Oracle Reports 10g/6i, PL/SQL, SQL Loader, TOAD,
iSupport Framework.
Bearing Point -- Wayne, PA Sept
2005 to June 2007
Oracle Apps Developer
. Involved in Oracle 11i Implementation for OLM, Collections, AP
and GL Modules.
. Performed Gap Analysis for AP, OLM and Collection modules
created MD050 and MD070 documents.
. Customized standard forms and reports using Forms/Reports 6i in
AP, GL and OLM.
. Developed new concurrent programs in PL/SQL and worked with
business users to gather requirements.
. Defined, analyzed and build error tables, status tables and
result tables.
. Customized OLM Termination Workflow using Oracle Workflow 2.6
. Performed Unit Testing for the new forms and reports.
Participated in User Acceptance Testing and resolved issues
identified during testing and created test document (TE020).
Technical Environment: Oracle Apps 11.5.10.2 (OLM, Collection, AP, GL),
Oracle 10g, Oracle 9i, Oracle Forms 6i, Oracle Reports 6i, PL/SQL, SQL
Loader, TOAD, PVCS, Test Director, Workflow, Kintana Migration.
Tata Consultancy Services Ltd (TCS) - Jamshedpur, India Sept 2003 to
August 2005
Oracle Apps Developer
. Served as an Oracle Application developer on extension team for
AR and AP module.
. Responsibilities included designing and developing User
Interface using Forms6i, custom reports using Oracle Reports 6i
and Packages.
. Performed application tuning and query tuning using Explain
Plan, SQL Tracing, and TKPROF.
. Provided end user training and created technical documents
MD070, TE020, etc.
Technical Environment: Oracle Apps 11.5.3, Oracle 9iAS, Oracle Forms6i,
Oracle Reports6i, SQL plus, PL/SQL, SQL Loader.
CMC Ltd - Calcutta, India February 2001
to August 2002
Programmer
. Involved in design, development and implementation of GENISYS,
an application designed and developed for General Insurance
companies of India, like NIC, NIA and UIIC.
. Designed and developed User Interfaces using Oracle Forms 4.5
and PL/SQL.
. Designed and developed ERD reports using Oracle Reports 2.2.
. Developed Forms, Stored Procedures, and Triggers. Performed
complete testing life cycle (unit test, integration test, system
test, user acceptance).
. Diagnosis and resolution of system issues identified during
testing.
. Provided on-site implementation Support and training in 4
different customer locations.
Technical Environment: Oracle 8.1, PL/SQL, Forms 4.5, Reports 2.2, SQL
Loader
.
Educational:
Bachelor of Engineering (BIT Sindri)
Contact this candidate