Management Oracle
Resume:
Usha Sagaram
Aurora,
IL *****, USA.
************@*****.***
Mobile 630-***-****
Experience in Brief
About 6 years of experience in implementing and
testing Oracle Applications.
Worked on Order Management, Inventory, BOM, Depot
Repair, Engineering, Oracle Receivables, Payables,
Purchasing and Sysadmin modules in both technical
and functional areas in Oracle Applications.
Performed Study of the existing systems, provided
business solutions using Oracle Applications,
designed and developed interfaces, conversions,
reports, packages and procedures, forms, shell
scripts etc. Did performance tuning of SQL.
Prepared test scripts for Order management,
Shipping and Inventory modules and Performed unit
testing and integrated testing.
Possess working Knowledge of Windows and UNIX
Operating Systems, Relational Databases, Toad,
Discoverer etc.
Responsible for interacting with business partners
to identify information needs and business
requirements for reports.
Interacted with users in setting up modules like
Engineering module.
Performed the functions of Sysadmin.
Analytical and problem solving skills. Team Player
with the ability to communicate effectively at all
levels of the development process.
Work Status
US Citizen
Special Skills Languages: SQL, PL/SQL
Reporting Tools: Discoverer and Reports 6i.
Database: Oracle 8i/9i.
TOAD 8.0/7.0
Operating Systems: Windows 95/98/NT/2000/XP, UNIX,
Sun Solaris
Worked on SOX Compliance issues.
Functional and technical analysis working on Order
Management, Inventory, BOM and Engineering
modules.
Creation of technical designs for implementing
solutions using Oracle Applications.
Design and development of Interfaces and
Conversion of data from legacy systems to Oracle
Applications.
Design and development of new reports using
reports R6i.
Design and development of new forms and integrate
them with Oracle Applications.
Preparation of test data and performing the
testing of reports, forms etc. for accuracy of
data.
Design and Development of database procedures,
functions and triggers.
Functions of system administrator.
Creation of database objects.
Certifications/Train
ing
A) Oracle Certification in SQL & PLSQL
B) Oracle Certification in Database Architecture.
C) Oracle Inventory Management Training.
D) PMI member.
Work Experience
UTSTARCOM, IL
March '10 to July '10
Worked as a consultant Analyst/System
Administrator for UTSTAR, a Telecommunications
company, on R12.
Worked on Order Management and Purchasing modules
resolving issues and catering to user requests.
Worked with off shore teams in India and China for
production support and problem resolution.
Actively worked on meeting SLAs and also followed
escalation procedures to get the resolutions
within the agreed times.
Worked on change management system using VSS for
all the source code control and SourceSafe for all
the documentation.
Developed ad hoc reports using Discoverer.
Worked on System Administrator functions.
Responsible for user access control, monitor and
maintenance. Also responsible for creating custom
responsibilities, maintenance of site level
profiles, setup of custom menus and functions,
setup of custom profiles, setup of report groups,
scheduling concurrent programs etc.
Wells-Gardner Electronics, IL
April 2008 to October 2008
Worked as Analyst/Developer/System Administrator
for Wells-Gardner, an Electronics manufacturing
company.
Helped in maintenance of Order Management module.
Setup customers and customer sites.
Setup and maintained price lists, price breaks,
pricing formulas etc.
Setup modifiers and qualifiers for advanced
pricing.
Provided sysadmin support functions like user
access maintenance, custom menu, responsibility
and report group creation and maintenance, support
to workflow notification issues, and rerun or
progress stuck workflow processes from Workflow
Admin, schedule concurrent programs, monitor
concurrent programs and coordinate action with the
users for the failed programs and maintenance of
oracle printers etc
Worked on production issues related to Order
Management, Purchasing, WIP, BOM, Inventory,
Receivables and other modules. Provided support
for the pick release issues and shipping related
issues in Order Management, Auto PO create issues,
PO approval issues and receiving issues in
purchasing, month end closing issues in inventory
etc.
Worked on Discoverer reports.
Developed several Oracle reports in Order
Management and WIP.
Fellowes, Itasca, IL
July 2007 - Nov 2007
Worked as a Developer/Analyst for Fellowes, a
manufacturing company.
Worked on Discoverer reports, Oracle reports, EDI
functions for 850 inbound and outbound, 810
inbound and outbound 856 outbound and Sysadmin
functions.
Interacted with the users to resolve production
issues and to gather requirements for
enhancements.
Provided simple solutions to complex requirements.
Provided discoverer reports for various user
requests.
Used SourceSafe for change control.
AAR Corp, Wooddale, IL
Aug 2006 to June 2007
Worked as a Business Analyst for AAR, an Airline
parts manufacturing company.
Worked on SOX Compliance issues. This involved
creation of new responsibilities, restricting the
users to their required functions. Also it
involved developing procedures for tracking change
management and approvals. Reviewed and finalized
business processes for proper approvals before
booking orders for SOX compliance.
Worked with users to setup Engineering module
suited to their requirements.
Modified the ECO Approval workflow to suit their
business process.
Involved in Physical Inventory.
Customized their Pick release form using
CUSTOM.pll
Customized and trouble shooted a lot of reports
like Sales Order Acknowledgement Report, Pick
slip, Pack slip, WIP Discrete Job Pick List
Report, ECO Summary Report etc.
Provided day-to-day production support in almost
all the manufacturing modules.
Copied BOMs for a new organization.
Worked with Oracle Alerts.
Created database objects like triggers, procedures
etc.
Worked to setup transaction types in Order
Management to deal with RMA issues in the company.
Made browsers using Discoverer for example a
browser to see hours applied to rework in WIP
jobs.
Setup Cost Rollup Sets for different Orgs.
Worked as a functional specialist in Inventory,
Order Management, Engineering, Receivables and
Depot Repair Modules.
Worked extensively in Order Management setting up
customers, advanced pricing features and pricing
formulas and applying them at the time of sales
order booking.
MAAS Inc., IL
Oct 2004 to Aug 2006
Oracle Applications Business Analyst
The project involved customizations, interfaces,
testing and conversions in Order Management
Module.
My involvement in the project:
Performed study of the existing systems, provided
business solutions using Oracle Applications,
designed and developed efficient processes, many
interfaces, conversions, reports, packages and
procedures, forms, Shell Scripts and workflow etc.
Did performance tuning.
Prepared Test scripts for Order Management modules
for creation of test orders for different Order
Types, progressing of orders from booking to pick
release, shipping, inventory interface and
invoicing.
Responsibilities
Functional consultant for implementing Oracle
Applications. Version 11.5.8 and database version
9i and 8i(8.1.7)
Designed customization of pick release and
shipping functions. The customization involved
creation of an outbound file with the picking
information to an external Siemens system and
upload of the actual shipped quantities from the
external systems back to Oracle.
Designed customization of Order Entry screen to
display freight options from various carriers and
calculate freight.
Customized Order Header Workflow and created new
workflows.
Taken care of all the open conversions like
Customers, Open Invoices, Open Orders and Items.
Created functional specs for the reports.
Actively involved in gathering requirements from
the end users.
Functional consultant in Order Management,
Shipping and Receivables modules.
Worked on Applications 11.5.6 version and database
8i.
Worked on open conversions like Customers, Open
Invoices, and Open Orders.
Sandy Corporation
2002 August to 2004 July
Technical Consultant for upgrading the existing
10.7 to 11i.
Upgraded Receivables module.
Performed migration of the reports, custom
procedures, forms etc. This included recompilation
of the objects, verification of the results with
the results of 10.7 outputs etc.
Performed tuning of the custom code that has
performance issues due to the migration.
Discussed with the end user regarding
customizations and new requirements.
Contact this candidate