Customer Service Oracle
Resume:
Bindu Kaki
********@*****.***
Overview:
. 5+ Years of experience in Information Technology as a Oracle
Applications Consultant, Involved in Analysis, Design and Development
of Oracle Applications using SQL, PL/SQL, Forms and Reports.
. Experienced in Data Conversions, Interfaces, Extensions, Customization
and New Development in Oracle Applications.
. Expertise in Software Development Life Cycle (SDLC) of Projects -
System Study, Analysis, Physical and Logical design, Coding,
Testing and implementing business applications.
. Experienced in Oracle Modules such as General Ledger (GL), Oracle
Payables (AP), Oracle Receivables (AR), Purchasing (PO), Order
Management (OM), Inventory and HRMS.
. Experienced in performance Tuning and analyzing using Tkprof, SQL
Trace, and Explain Plan.
. Having strong experience in MVC architecture through OA Framework,
Customizing Self Service pages (OA Framework Pages) as well as
Personalization of the existing pages in different Modules.
. Experienced in Up-gradation, Implementation and Production Support of
Oracle Application 11.5.8/11.5.10/R12.
. Experience with Electronic Data interchange (EDI) and Application
Desktop Integrator(ADI)
. Expertise in Application Object Library (AOL), System Administration.
. Extensive experience in Oracle backend objects like Database Triggers,
Stored Procedures, Functions, Cursors and Packages using PL/SQL.
. Expertise in developing database applications using Oracle with
Developer 2000 (Forms 6i, Reports 6i).
. Experience in using XML/BI Publisher for reports and Customization of
Workflow using workflow Builder
. Experienced in Developing Technical Specification and Design Document
using AIM (Application Implementation Methodology).
. Having strong Business and Analytical skills.
. Excellent team player with people management and problem-solving
skills.
. Excellent communication and interpersonal skills.
Technical Skills:
ERP : Oracle Applications 11i/R12.
Modules : GL, AP, AR, OM, PO, INV, HRMS
Oracle Fusion : Oracle SOA Suite 11g, BPEL, Mediator, Human Workflow
Operating Systems : MS DOS, Windows NT/2000/XP, UNIX
Languages : Shell Script, Java, SQL, PL/SQL, Java Script
Web Programming : JDBC, Servlets, JSP, HTML
Database : MS SQL Server 7.0/2000, Oracle 8.x/9i/10G
Tools/Utilities : TOAD, SQL*Loader, Developer 6i, Discoverer
Professional Experience:
Wizard Systems Inc.
Apr2008 - Till Date
JR 286 Inc. - Los Angeles, CA
Oracle Apps Technical Consultant
JR286 is a leader in the manufacturing/distribution of branded and licensed
sports accessories.JR286 is the best in class branded Accessories Company
across all functions - including Customer service, supply chain management,
logistics and information technology.
Responsibilities:
. Development of Reports using XML/BI publisher.
. Design and development of PL/SQL programs to load the data from legacy
system to
Oracle tables using interfaces and API's
. Working on EDI 850/810/856 transactions.
. Involved in the development of PL/SQL programs and Reports in OM and AR.
. Interfacing between the client and the offshore team.
. Development of EDI exports and imports with the Oracle EDI Gateway.
. Customization of self service pages using OA Framework technology.
. Worked on Customization of purchasing approval workflow.
. Extensively utilized the Application Object Library to Register Programs,
PL/SQL Procedures and reports. In addition, also used the System
Administrator responsibility to create users, responsibilities, Value and
Request Sets, Menus and Submenus.
. Working on the Customization of Forms and Reports.
. Performance tuning of the application programs using EXPLAIN PLAN, TKPROF
. Worked on the development of reports based on the client
requirements.
. Involved in the preparation of Technical Design Documents using AIM
methodology.
Environment: Oracle APPS 11.5.10, Oracle 9i, Reports 6i, Forms 6i, TOAD,
OM, AR, AP, INV, PO, Gentran Server, UNIX, SQL * Loader, XML/BI publisher,
OA framework, Jdeveloper, Workflow Builder
NEW Customer services company, VA
Oracle Apps Technical Consultant
N.E.W. Customer Service Companies, Inc. (NEW), has been the
Industry's leading provider of extended service plans and product
protection programs for consumer products.
NEW protects the products of more than 150 million consumers worldwide.
Responsibilities:
. Used Auto Invoice Interface to import Standard Invoices from a Legacy
system into Oracle Receivables using a control file, PL/SQL
Packages/Procedures and Auto Invoice Import program.
. Involved in the conversion of Customers Information from Legacy to
TCA using custom program and using APIs.
. Worked on uploading the data to oracle GL using Web ADI.
1. Modified Customer Validation Program in Receivables.
2. Enhanced iprocurement Functionality using OA Framework technology.
. Writing UNIX shell scripts for the development.
. Involved in designing and developing various reusable packages and
procedures which were utilized by various programs
3. Involved in the preparation of Technical Design Documents using AIM
methodology.
Environment: Oracle Apps 11.5.10, HP UNIX, Oracle 10G, Forms, Reports,
TOAD, GL, AR, AP, PO, HRMS, JDeveloper, XML/BI publisher, OA Framework,
Discoverer
Schneider National, WI
Oct2007 - Mar2008
Oracle Apps Technical Consultant
Schneider National, Inc. is a premier provider of truckload, logistics and
intermodal services. Serving more than two-thirds of the FORTUNE 500
companies, Schneider National offers the broadest portfolio of services in
the industry. The company's transportation and logistics solutions include
Van Truckload, Dedicated, Regional, Bulk, Intermodal, Transportation
Management, Supply Chain Management, Warehousing and International
Logistics services.
Responsibilities:
. Responsible for data conversion from legacy to oracle application.
. Development of Reports using XML/BI publisher.
. Developed PL/SQL packages, procedures, functions for interface program
to validate the data for the following modules: HRMS, Payroll
. Developed an interface program written in shell script to load data
from legacy system and attached to request set with open interface
input program.
. Created FSG Reports as per Business User's Requirements.
. Created Reports using Discoverer as per the requirements given by the
Business Users.
. Developed Custom Interface to import vendor's information from legacy
system to Oracle Application.
. Involved in the creation and registration of Menus, Submenus,
Functions, Flex fields and Profiles using AOL.
. Involved in the creation of Users and Security groups using System
Administrator Responsibility.
Environment: Oracle APPS R12, Sun Solaris, Unix, Windows NT, Oracle 10G,
TOAD, SQL*Loader, PL/SQL, SQL* Plus, AP, AR, PO, HRMS, GL, System
Administration and AOL.
HCL Technologies, Chennai, INDIA
Hewitt-Sun Microsystems Jun 2006 -
Feb2007
Associate Consultant
HCL Technologies is a leading global IT services company, working with
clients in the areas that impact and redefine the core of their businesses.
HCL is a $5.3 billion leading global technology and IT enterprise.
HCL has partnerships with several leading Global 1000 firms, including
leading IT and technology firms.
Responsibilities:
. Developing SQL Reports
. Creating custom packages & procedures
. Creating Database Objects
. Worked on Forms Personalization in HR
. Extracting personal data of employees using API
. Preparing Unit test cases for SQL Reports
. Involved in writing PL/SQL packages while developing the interface.
. Performance tuning of SQL queries in the existing programs
. Involved in pl/sql programming and UNIX scripting.
Environment: HP Unix, Oracle Database 8i, Oracle applications 11.5.8, HRMS,
Forms 6i, Reports 6i, Unix, Shell Scripting.
HCL Technologies, Chennai, India
Reed Elsevier Jun 2005 -
May2006
Junior consultant
Responsibilities:
. Modification / Preparation of MCD / AID / MD70 documents for the
customizations.
. Involved in writing PL/SQL packages while developing the interface.
. Conversion of Reports / Forms (Reports2.5 to Reports 6i and Forms
4.5 to Forms 6i).
. Package and shell script modification.
. Testing of to-be-processes
. Technical Support for integration, UAT and production.
. Registration of Concurrent Programs and Request Sets in AOL
. Development of custom reports in AP, AR and PO modules.
. Design and Development of Interfaces and other customizations.
. Defined value sets, key Flex field segments.
Environment: Oracle Applications 11i (11.0.3, 11.5.8), PO, AR, OM, INV,
Oracle 9i, Reports 6i, Forms 6i, SQL, PL/SQL, TOAD, PVCS.
Comp-u-learn Technologies, Hyderabad, INDIA May 2004 -
Apr2005
Oracle Apps Training and Development
Responsibilities:
. Design and Development of Interfaces and other customizations.
. Defined value sets, key Flex field segments and roll-up groups with
security and cross validation rules.
. Developed Pl/SQL code for real-time import of customers into oracle
Receivables.
. Created a very user-friendly GUI interface, with extensive use of
features of Oracle Forms 6i.
. Used various levels of triggers and procedures to validate the data at
each level.
. Responsible for customizing reports and writing the reports with required
specifications.
. Customizing the application forms to meet the specific business needs
using built in features available with (Template.fmb) form, built-in
stored procedures and attached libraries.
Environment: Oracle apps 11.5.8, Oracle 8i.
Contact this candidate