Oracle Sql
Resume:
Arti Adya
Exton, PA, *****
Phone: 732-***-**** (Cell)
Email: *************@*****.***
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