Career Summary

IT Professional with over 13 year’s extensive experience in Oracle Applications. A resolute problem solver with strong interpersonal, analytical and communications skills. Technical savvy combined with strong work ethics will add value and impact bottom-line results. Demonstrated ability to work effectively at all organizational levels with both internal & external customers.

Professional Experience

Confidential,2009-Present
Role: - Oracle Application Tech Lead
Worked on Oracle iProcurement, OAF (Oracle Applications Framework Customizations) for Requisitions Notifications, done Oracle iSupplier Setups

Confidential,2006 – Jan2009
Traveled and worked as a consultant for various clients, both national & international, customizing their ERP systems. Some of these project spans were as small as 2 weeks and some lasted for 4-6 months.
Role: - Oracle Application Consultant.

Client companies included - Confidential,TX - Worked in Oracle iPayment for German EFT Direct Debit Program, Bank Reconciliation using oracle Cash Management, AP Check fraud prevention in Oracle Apps - Payee Match with Positive Pay, Lockbox Reconciliation Extension, It was an Upgrade from 11.5.9 to R12 for Oracle Financials

• Citco Financials Group - Edison, NJ - Worked on SQL*Loader Scripts.
• Herbal Life - Torrance, CA - Worked on Order Management Reports with an input to Optio.
• Sun Microsystems - San Jose, CA- Worked in Informatica for Datawarehousing Project.
• Cisco Systems - San Jose, CA - Worked on XMLP reports to generate the web letter through Workflow Subscription.
• Smucker’s - Orrville, OH - Customized Standard Budget Workflow in Oracle Project Costing adding hierarchy part to it.
• CVRD - Brazil - Functional resource working on the Order management Module checking all the setups originally done by Deloitte, Brazil

Confidential,Houston, TX - Developed Reports in XML Publisher for R12. Developed both Check printing report on Pre-printed Stationary and Contract Details report in XML Publisher. Customized the Oracle Service Contracts Workflow to send notification to the salespeople who are outside of Oracle domain. It was an Upgrade from 11.5.9 to R12 for Oracle Financials

• Confidential,Pella, Iowa - Worked on Work in Process Module,Functional expertise in OTM 5.5/5.0

(Oracle Transportation Management) Performed business requirements gathering, functional design documents and configuration. “Effective transportation management was able to control, and manage, both fleets as well as for-hire carriers,”
Confidential,Wisconsin - Booked a Sales Order Line using Release Management. This module populates the Order Management Interface Tables. Booked a Sales Order Line By EDI 830 Inbound planning Schedule. This Module populates the Order Management, Interface tables. Worked on Outbound 862 Shipping Schedule (DSNO)

• Confidential,OH - Worked on a Custom Auto Invoice program in PL/SQL. Setup an Oracle Configurator development or test environment, Import PTO and ATO BOM Model structures and Item Master data into Oracle Configurator Developer, Use Oracle Configurator Developer to enhance the configuration model, Perform engineering calculations, Integrate with an alternative User Interface, Write custom rules that cannot be created using OCD
• Confidential,OH - Worked in OIC(Oracle Incentive Compensation) to calculate and pay commissions for salespersons based on incoming transactions. OIC Processes have a simple user interface with a couple of standard input parameter integration with Oracle Payroll. OIC is a global variable compensation application that automates the design, administration, and analysis of incentive-based compensation programs to successfully drive corporate goals. OIC enables "pay for performance" while maintaining necessary financial controls. OIC allows organizations to connect sales incentives to business objectives to motivate workers (sales reps), 3rd party representatives, customers / suppliers, resellers and partners. OIC automates the complex task of modeling and calculating incentive payments.
• Created an order using configurator and book the order through OM. Knowledge of Advanced Pricing Module and Integration to Configurator Pricing. Thorough understanding of Configurator-APIs for integration & extensions.
• Good integration knowledge between Oracle Configurator and Oracle Advanced Pricing/Contracts/Quoting.
• Worked in Oracle Interconnect and XML gateway to generate outbound 810 for Invacare Customers.
• Did Trading Partner setups, Created Custom maps for Customers in Oracle XML Designer.

Confidential,Role: - Oracle Application Consultant

JTEKT

• Creating a Work Order using MIN MAX, Receive a product using ASN, Receive AP Invoice through EDI INI, Return to vendor with Automatic Debit Memo Creation.
• Performance management in People Tools
• Migrate roles from one database to another database
• Web Application Servers with People Tools 8.1x and People Tools 8.4
• Good knowledge of Inventory Organization Transactions, consigned Inventory, FIFO Costing
• Discoverer 4i, Discoverer 4.1.37.00.0 - Created Workbooks, Worksheets, Cross Tab, Page detail Cross tab, Page Detail Table Reports. Knowledge of data points and axis items in cross tab reports
• Trained users use discoverer as an ad hoc query tool to develop reports and retrieve data from respective business folders.
• Worked on Discoverer Admin side - Created EUL (End User Layer), summary tables, (i.e. materialized views), and database user in discoverer admin. Scheduled workbooks, shared workbooks to other users, exported workbooks to excel and HTML format. Created calculations, functions, and percentages in discoverer.
• Created analytical functions, alternative sorts, item classes, hierarchies (Date and item hierarchy) on Discoverer admin side
• Worked on both standard EUL as well as Apps mode EUL. Generated the business areas using NOETIX EUL, worked on NOETIX Views, Noetix EUL Generator and Oracle Business views (Oracle BIS).
• Customized the COGS Workflow. Added new functions to select account information from customer site level.
• Worked on Order Capture APIs in oracle Quoting, creating quotes from templates.
• Worked on purchasing setups like creating an employee, buyer, jobs, positions, and position hierarchy. Approval groups and Oracle Purchasing Lookups.
• Familiar with the document types in purchasing setup.
• Worked in Oracle Workflow Module (Engineering Change Order), Creating Jobs, Position Approval Groups, and Security Attributes determining Line Duration reviewing Pricing Attributes.
• Worked on BIS (Business Intelligence System) in Apps mode Discoverer Purchasing Intelligence, Operations intelligence, financials intelligence, HRMS intelligence.
• Wrote a custom label-printing program, which is a source for Easy Label.
• Installing & Configuring the Oracle Grid Control.
• Implemented Oracle 10g new features Transparent Data Encryption (TDE), SQL Plan Management and Flash Recovery Area.
• Strong experience in Database migration and up-gradation in various platforms.
• Done several Database patch-set installations as well in one-off patch installation using patch.
• Experience in working with Production as well as Development environments.
• Strong experience in Backup & Recovery, in user managed backups as well with Recovery Manager (RMAN).
• Strong experience in Database troubleshooting with various oracle database releases.
• Actively involved in Database Design & Shell Scripting.
• Good Knowledge in Installation of Oracle with 8i, 9i, 10g and 11g on various platforms like Sun SPARC, LINUX, HP and Windows platforms and creating customized databases.
• Configuring and Maintaining Shared Server, Enabling Archiving and Maintaining Archive log files, Installing and configuring SQL*Net on Clients.
• Have ability to perform root cause analysis, Performance monitoring and application related issues
• Database (Oracle 8i, 9i, 10g, 11g) - Server and client installations, database creation, creating users, assigning privileges, roles, quotas, profiles to users.
• Strong experience in patching, OEM troubleshooting.
• Cloning of various databases using various methods including create control file, RMAN.
• Applying CPU (Security) patches on different platforms for different issues.
• Extremely dedicated, self–motivated, Pro-Active and willing to assume responsibility.
• Experience as On-Call 24x7 production DBA support, development DBA.

Confidential,Troy-MI 2003 - 2003

• Applied service charges to product (order) lines. Process was workflow based; Items Instructions for services are based at the customer item level.
• Technical design documentation for the custom pick release, Order load, Item Extract.
• Pick Release Process modifications and customized Pick Slip reports.
• Form development - Custom Pick release Rule and Custom Release Sales Order form.
• Design and development of reports - Fill rate, Order Grouping and Ticket exceptions.
• WMS – Setup of Pick and Put away rule and strategy design, Express Receipt, WMS interface
• Item extract using Taviz (ETL), Integration testing and Migration of Custom objects.
• Configuration of OM and shipping modules for functional team.
• Performance Tuning of the Order Load and Pick Release Process
• Report development - Character reports, Daily Orders Report, Inv Shortages Report, and Shipment Exception Report
• Worked on HRMS (Application programming Interface) to create employees, dependent, address, updating assignments, managing employee data
• Development of interface between Payables and Vertex for use tax calculation.
• Development of conversions and interfaces for Oracle Receivables, Fixed Assets, General Ledger using SQL*Loader and Taviz
• Performed extensive SQL, PL/SQL tuning using various Oracle Tools such as TK-PROF, Explain Plan, Level 8 trace, creating snapshot of the database.

Confidential,TX 2003 - 2003

Custom Forms Development, and upgrade from 10.7 to 11.5.7

• Migrated all customized forms from Oracle Applications 10.7 to 11i using Designer 6i and Flint 60 method for custom forms.

Confidential,OH 2002 - 2003

• Customized the shipping reports i.e. Bill of Lading, Commercial Invoice, Pick Slip Report.
• Worked on Oracle Trading Community Architecture (TCA), mapped all the Data Warehousing Order Entry queries to the corresponding queries using Oracle Hot Zone Tables (HZ tables in 11.5.8)
• Developed Open Interfaces in Oracle Purchasing module called Purchasing Document Open Interface (PDOI)
• Created a contract in Oracle Core Contract (OKC) from a template, Copy contract from an existing contract, Contracts Party details and Party Merge, Extended Warranties etc
• Developed Accounts Receivables Customer Interface
• Worked on Multi language Reports (invoice Report, Sales order report in European Languages) using Oracle translation Language Tables
• Customized Sales Order Forms
• Migrating all customized forms from Oracle Applications 10.7 to 11i.
• Knowledge of oracle database. Character set nls_sort, nls_language
• Manual entry of the party number in Telesales, address validation, reciprocal relationship, duplicates party check. Knowledge of TCA API’s and Profiles.

Confidential,MI 2000 - 2002

• Worked on various Oracle Reports - Bitmap Report, Character Report, Matrix report, Nested Matrix Report, Conditional Duplex Report, Check printing through Report, Purchase Order Report, Invoice Print Report and Requisition Activity Summary Report
• Worked on manually renewing a contract and also auto renewal of a contract.
• Worked on AP, AR, HR to People Soft interfaces
• Customized the process developed for Engineering Change Order (ECO) Approval Workflow
• Customized Order Management Workflows
• Worked on shipping API’s

Confidential,Kalamazoo, MI 1998 - 2000

• Developed Pack Release Order Customization, an MRP-like program that drives the entire material handling and packing process for after market operations
• Performed setups of Order Cycle, Order Types, and Standard Value rule sets, quick codes and hold.
• Performed Inventory transactions such as Sub-inventory transfer, miscellaneous receipts, checking availability of components, verifying and creating Bill of Materials.
• Created BOM Explosion Reports.
• Responsible for the successful implementation of OE module for Eaton/Dana Corporation.
• Member of data conversions/Interfaces team for Quest 21/Endevour 2000 and responsible for Order Entry Module.
• Developed a PL/SQL program to import the price lists from COPICS system into Oracle.
• Involved in loading catalogs, catalog values and adding descriptions.
• Performed analysis to load the customer items at the customer level and at the customer address category level
• Loaded customer items into Oracle automotive tables using PL/SQL.
• Programmed material handling and packing process for after market operations.