Arti Adya

*** ********* **,

Exton, PA, *****

Phone: 732-***-**** (Cell)

Email: abon8k@r.postjobfree.com

SUMMARY:

. Over 14 years of IT experience

. 7.5+ years of experience with Oracle ERP and Oracle Tools; the

experience comprises of implementing that includes Data conversions,

Data Migrations Conversions, Interfaces, Upgrades and Customization

. Functional responsibilities: Participated in the analysis, design,

development, unit testing and documentation for small to medium system

enhancements, test script generation, training end users, and

production support

. Technical activities: interfacing with users, designing custom

solutions, programming, scheduling, producing documentation, and

providing production support

. Expertise in Customizations, Migrations, Conversions, Interfaces in

Oracle Applications 11i [GL, AP, AR, System Administration, Oracle

Applications Programming Interface (API's), Open Interfaces]

. Extensive experience in Oracle 10g, 9i/7.x, Developer 2000/6i, PL/SQL,

SQL, SQL*Loader, Data Loader, Discoverer, Oracle Application

Framework.

. Experience in building Forms, generating Reports and registering them

as concurrent programs in Oracle applications using AOL

. Experience in writing Interface programs for importing data from

feeder systems to Oracle using Java, PL/SQL and oracle API

. Worked on upgrade of Oracle Applications from older version to 11i

upgrade

. Extensive experience in pl/sql programming for 10 years. Worked on

stored procedures, functions, packages, triggers, dynamic sql

. Excellent communication skills, team player, quick learner

SKILLS:

Oracle ERP: R12, 11i, General Ledger (GL), Accounts Payables

(AP), and Accounts Receivables (AR), Inventory

(INV), Order

Management (OM), Purchasing (PO)

Oracle Tools: SQL*PLUS, SQL*Loader, Oracle Discoverer

Other Components: Workflow/ Workflow builder, Alerts (ALR),

Application Object

Library, Concurrent Manager (CM), Flexfields,

OA Framework

Databases: Oracle 10g, 9i, 8i, 8, 7.x, MS Access, MS SQL

Server 6.5/7.0/2000

GUI: Developer 2000/6i, Discoverer 10i

Languages: SQL, PL/SQL, JavaScript, UNIX shell scripts

Version Control Visual Source Safe, SCCS for UNIX, PVCS

Tools:

IDE: SQL Navigator, TOAD

PROFESSIONAL EXPERIENCE:

Cigna (Pennsylvania)

(JAN-10 - Till Date)

App Development Sr. Specialist

. Currently working on production support for business customers for AR,

AP, FA and GL module and also involved in new development

. I have developed various XML reports for CPAY. I successfully designed

and test this technical solution and skillfully utilized the XML

technology into CPAY. This technology was not used in CPAY until now

in my group. I have provided this innovative solution that increases

the operational value. I shared my knowledge by giving presentation on

XML technology to support business objectives

. With a very quick and short knowledge transfer for AR production

support, I am providing a solid primary production support to AR

application and also guided my team mate as backup support for this

application

. Addressed issues with sense of urgency and resolved them within

acceptable time limits. I was able to quickly understand customization

for EDI, invoice interface, Margins in order to debug issues while

doing production support or closing

. I have assisted in providing evidence for Oracle Corporate General

Ledger application to Internal Audit and SOX Audit teams

. Successfully implemented technical solutions to business problems (

Any modification to current EDI setup or any issues reported by

customers)

. Followed all procedures of change management to fulfill audit purpose

. Independently supporting Intracorp and handling AR Close all alone

. Coded, tested, documented and maintained programs

Kenexa (Pennsylvania)

(JUN-08 - DEC-10)

Sr. Programmer Analyst

. Worked on AR/AP/GL modules on the day-to-day operation of the

Departments, for both technical and functional issues

. Coded and tested custom report changes for invoices in AR/AP and GL

. Prepared test documentation for the enhancement and creation of custom

Oracle reports and new oracle functional enhancements

. Also worked on workflow customizations and interfaces to get data from

flat files to Oracle projects tables

. Got introduced to Oracle projects and got exposure to XML reports

. Developed and prepared specifications for ongoing reports and queries

to support management needs

. Developed interfaces and data conversion programs for applications

. Resolved open issues related to data integrity, setup issues, and

transaction errors

. Provided effective user support for various planned enhancements and

upgrades

. Provided periodic financial data to SOX and internal Auditors as per

the requirement set for specific periods

. Developed forms using Oracle Application Framework.

Burlington Coat Factory. (New Jersey)

(JUN-05 - APR-08)

Sr. Programmer Analyst

Project: Oracle Apps upgrade from 10.5.10.2 version to 11i

Oracle Modules: Oracle Accounts Payables (AP), Oracle General Ledger (GL)

Description: This project was upgrade to 11i apps, involved lots of

customized code conversion for reports and forms and also needed setups

related to Menu, responsibilities and flex field setups.

Responsibilities:

. Provided analysis, design, installation, and rollout of Oracle 11i

Accounts Payable and General Ledger

. Worked on modification of various custom Reports and Forms 11i. Also

recoded UNIX shell scripts and sql scripts for 11i

. Designed interface/conversion mapping, pre-production testing, and

related documentation and deliverables

. Created and maintained the post upgrade installation/ clean-up process

checklist for the projects

. Extensively involved in system admin related setups such as creating

responsibilities, menus and adding reports to user groups and creating

flex fields

. Maintained proactive interaction with the users to understand business

practices and helped users for functional problems

. Worked on lots of custom reports and few discoverer reports

. Wrote UNIX scripts to get data from external systems to oracle AP for

invoices and vendors and such information from Oracle to external

systems

. Wrote pl/sql stored procedures and functions, packages for oracle

reports and used dynamic sql also

. Updated the invoice upload program to add new source which included

Unix script, pl/sql program and concurrent program

Environment:

Oracle Apps 11i, Oracle Database 9i, GL, AP, AR, Pl/SQL, SQL*Plus, Forms

6i, Reports 6i, Windows XP, UNIX

Able Laboratories (New Jersey) (APR 02 - MAY-05)

Sr. Programmer Analyst

Project: Oracle Apps 11i Implementation

Oracle Modules: Oracle General Ledger (GL), Accounts Payables (AP),

Accounts Receivables (AR),

Description: Oracle Apps 11i Implementation-- Extensively involved in

developing conversion programs interfaces, customizing reports, building

custom reports based on the functional specifications provided.

Responsibilities:

. Wrote pl/sql stored procedures and functions, packages for oracle

reports and used dynamic sql. Used complicated sql and plsql for

customized reports to generate reports from ERP database

. Created tables, indexes, triggers while working on data conversion

. Wrote SQL scripts to create temporary tables and wrote java programs

to load the legacy data into the temporary tables

. Extensively used TOAD to create pl/sql procedures, functions and triggers

. Designed and developed procedures utilizing various seeded APIs to

load data from temporary tables into Oracle base tables. (Inventory,

Item Master)

. Developed a single program to import invoices into Oracle Payables

from three different sources and registered this as a single

concurrent program which was used by these sources

. Data loaded into temporary table from a java program and then into

AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables.

. Customized various reports in Manufacturing PO, Pick ticket, Return

orders

. Developed custom reports using Report 6i and also customized seeded

reports

. Extensively utilized the Application Object Library to register PL/SQL

procedures and reports. In addition, used the System Administrator

responsibility to create users, responsibilities, Value Sets and

Request Sets

. Documented all the work done for future reference

. Wrote queries and plsql procedures for Financials modules (AR, AP, GL)

to the controls for the in-house application of Sarbanes-Oxley

. Worked on different internal applications using JSP, java script and

My Sql database

. Also worked on the systems for QA/QC departments for stability, COA

(Certificate of Analysis) and e-sample (sample tracking system)

. Developed stability system for R&D and inventory tracking System,

Sales order and charge back systems for samples. Developed two systems

in MS access for Document Control and QA department

. Involved in developing validation protocols for all labs related

systems and developing the system CFR11 compliant that uses

"electronic signature Audit trail" functionality

. Worked on the projects- Elab-COA (Certificate of Analysis) and Elab -

Stability system

Environment:

Oracle Apps 11i, Oracle Database 9i, GL, AP, AR, Pl/SQL, SQL*Plus, Forms

6i, Reports 6i, Windows XP, UNIX

Com.sortium (New York) (DEC 1997-MAR 2001)

Software Developer

This company provides Internet based solutions for automating and

integrating the recruitment process

within the enterprise. The process spans across multiple aspects

of HR functions in the organizational

context i.e. job advertisements, job search, job applications,

resume match, applicants evaluation,

inter-corporate hiring management. The system can be customized at

all levels and for all kinds of users:

applicant, customer (Employer), administrator. It has a generic

Web interface which can be fully

customized by definition of controls, events and dependencies etc.

The development environment includes ORACLE Web server

under Windows NT, Context server utility and spatial data option.

. My roles and responsibilities include a wide spectrum of

activities during the customization phase

for the key clients. Some of the tasks including but not

limited to are development of the

applications using dynamic PL/SQL, web server and Java script

and a set of administrative

tasks like import, export, tuning, and data loading using SQL

loader

. Client and functional team interaction for business process,

requirements gathering and analysis

. Providing all kinds of production support for applications & software

. Worked on AP, GL modules

. Modification and enhancement of Oracle Reports

. Worked on Oracle forms modification and form personalization

. Worked with Oracle for getting support on Oracle standard components

ITT. Hartford, CT (JUN

1997-SEPT 1997)

Consultant

Investment systems:

This system serves as the vehicle to maintain the portfolio data

of ITT Clients. This served as a tool to track

changes in portfolio and also keeping track of transactions. The

system is already in production. The portfolio

includes stocks, bonds and other financial Instruments. My task

involved creating database synchronization

scripts for Development, production and QA instances. This was

developed using dynamic SQL to create scripts

which used a driving table to pass table names and SQL Statements

as parsed values and instance name as an

external parameter. The development environment was

ORACLE7.3 on NT and SQL Navigator. The front end used was Oracle

Forms 4.5 for adhoc queries.

. Provided all kinds of production support for applications & software

. Involved in creation of a variety of forms for such activities

. Arranged meets with team member and with user to discuss different issues

. Created different database object such as tables, synonyms, indexes,

sequences, and views.

. Simulated and analyzed the reported Problem. This usually involved a

code walkthrough of Interfaces, Workflows, Forms & Reports and SQL

Scripts

. Worked closely with Oracle, Sys-admin & DBA teams for regular Patch

Applications, Outages, data fix, code fix, Scheduling of several

scheduled requests

SIS (Sales Information System). (New Jersey)

(JAN 1996 - MAY 1997)

Software Developer

The objective of this project is to have sales and order entry

Systems database for a stones (marbles, granite

etc.) import company based in the US And having offices across US

and Canada. The development environment is ORACLE7 and Visual

Basic in client server on NT platform. This is a migration from

single User Access based system to shared Oracle

database.

. Arranged meets with team member and with user to discuss different issues

. Converted Existing Access Forms GUI to Visual Basic front end

. Created reports in ORACLE SQL*PLUS and used PL/SQL to develop common

procedures and functions

. Data migration in Oracle tables using data access controls and ODBC

. Daily reports were created using sql plus report commands and pl/sql

packages like dbms_output

. Involved in extensive coding using Oracle PL/SQL

. Oracle SQL were tuned for best Performance using explain plan for

execution path

EDUCATION: BS - Shivaji University, India.

Contact this candidate