SUMMARY

• 10+ years of experience in Information Technology (IT) as a Techno Functional Consultant designing, developing and implementing Oracle Applications / Oracle e - Business Suite (EBS).
• Working experience on Oracle Applications Modules: Financials(Account Payables(AP), Receivables(AR), General Ledger(GL), Sub Ledger Accounting, iExpenses), Manufacturing (Bill of Materials(BOM), Work In Process (WIP), Oracle Process Manufacturing (OPM)), Logistics (Oracle Inventory(INV), Shipping, Warehouse Management system (WMS)), Purchasing(PO), Service (Service Contracts, Install Base), Supply Chain(Order Management(OM), Pricing(QP)), Oracle Projects-PA (Project Costing, Project Billing), Human Resources(HRMS).
• Strong experience in implementation; upgrade; RICEW (Reports, Interfaces, Conversions, Extensions and Workflows) development, Data Conversion.
• Expertise in SQL; PL/SQL; Oracle Reports; Forms; XML / BI Publisher; Discoverer; Workflows.
• Strong Knowledge of Application Implementation Methodology (AIM)
• Good knowledge in Performance Tuning Techniques.
• Proficient in writing Shell Scripting and registering them as Host Programs.
• Good knowledge in Oracle R12 OLAP (Online Patching) Standards.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using SQL*Loader.
• Application object Library (AOL) implementation standards and TCA.
• Development knowledge and good exposure in customizing and personalizing Oracle Application Frame Work (OAF) screens.
• Worked extensively on developing stored Procedures, Packages, Functions, Database triggers, Exception handlers, Cursors, Analyitical Functions.
• Expert in creation of concurrent programs, executables; registration of forms and reports, creation of Users, responsibilities, functions, value sets, request sets, request groups and lookups in EBS.
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles, Manufacturing, Oracle Projects and HRMS business flows.
• Experienced in opening and managing Oracle Support TARs (Service Requests) and be adaptable to high paced and tense severity 1 issues resolution
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.

TECHNICAL SKILLS

• GUI Tools: JDeveloper10g/9i; Forms 10g/6i; SQL*Loader; SQL*Plus; SQL Developer; Toad; Visio; VSS; PVCS; Kintana, XML / BI Publisher (BIP); Reports 10g/6i; Oracle Discoverer 10g/9i; OAF, Workflow Builder; Optio
• Databases: Oracle 11g/10g/9i/8i
• ERP: Oracle Applications 11i, Oracle e - Business Suite (EBS) R12.X
• Languages/ Frameworks: C, C++, SQL, PL/SQL, Jdeveloper, Java/J2EE, OAF, HTML, XML, Shell Scripts
• Methodology: Application Implementation Method (AIM)
• Utilities: Putty; WinSCP; SVN; Piper

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Senior Developer

Environment: Oracle Applications R12.2.5 Upgrade

Responsibilities:

• Developed OLP compliance reports:
• OLP DB Compliance Report to fetch the OLP DB Violated objects
• OLP File System Compliance Report (Shell scripting report) to fetch the OLP File system Violated Objects thereby improving the performance.
• Bug fixes and enhancements in OM and Finance Tracks.
• Involved in PPM Optimization fixes.

Confidential, Sunnyvale, CA

Technical Lead

Environment: Oracle Applications 11.5.9, SQL, PL/SQL, Unix Shell Scripting, PVCS, Kintana, Putty, WinSCP.

Modules: Oracle Receivables(AR), Order Management(OM, INV)

Responsibilities:

• Involved in vendor calls, Kick off meeting ; Requirement Gathering with Business Users, Vendors.
• Daily interaction with System Analysts and Business Users to understand the existing system.
• Key role in replacing the existing AR Credit and Collection activities System (Aceva) with new third party system (GetPaid)
• Guiding the offshore team to deliver the interfaces ARCUST, ARMAST, AREXTI, ARTRAN and ARCASH interfaces.
• Responsible for analysis, Technical design and implementing the solution.
• Managing the work done at offshore having daily offshore calls and reviewing the work on daily basis.

Confidential, Pasadena, California

Sr. Oracle Techno Functional Consultant

Scope: Oracle R12 Re-implementation (11.5.9 to 12.2.4)

Environment: Oracle Applications 11.5.9, 12.2.4, SQL, PL/SQL, Reports 6i, XML/BI Reports, Workflow Builder, OAF, Unix Shell Scripting, PVCS, Putty, WinSCP

Modules: Oracle Projects(PA), Purchasing(PO), Financials(AP, AR, GL, FA), SLA, and Core HR

Responsibilities:

• Interacted with business users, analysts to gather, understand, and analyze the requirements.
• Involved in the discussions to reduce the number of customizations in current 11.5.9 system to improve and streamline the customizations wherever possible.
• Development and uplift of CEMLIs from 11.5.9 to 12.2.4
• Customized the standard project supplier invoice and PO account generator workflows to use the business defined auto accounting rules and generate the distribution charge accounts
• Trained the team and the users regarding the Error handling mechanism incorporated in the Auto account generation programs and how it helps in identifying and resolving the issues faced during the charge account generation
• Created IWA(Intercompany Workflow Authorization) workflow to send notifications regarding the cross charge transactions
• Developed object to convert PDF files into BLOB Objects
• Created custom shell scripts: To submit the concurrent programs and move the generated request outputs to destination directory, Send the output as an email attachment
• Interacted with the business users to understand the existing Labor Cost Distribution(LCD) Payroll process for in 11.5.9, Analyzed, designed and interfaced to 12.2.4 Oracle SLA(Sub Ledger Accounting) with supporting Balancees using XLA JOURNAL ENTRIES PUB PKG
• Created Oracle Alerts to alert the account balancing information with debit and credit details.
• Converted Oracle 6i reports to XML/BI Publisher reports and redesigned them to meet the new requirements
• Designed and implemented dynamic grouping in the BI Reports
• Involved with XML/BI Barcode Reports to modify and setup the barcode font to appear on the report output
• Uplifted the Financial report - AP Invoice Register critical in SOX Audit to meet the new requirements: data model changes, add/modify the parameters, display summarized data
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes
• Migrated the code to other environments using STAT Configuration which uses shell scripting internally.

Confidential, Denver, Colorado

Sr. Oracle Techno Functional Consultant

Scope: Oracle R12 Upgrade

Environment: Oracle Applications 11.5.8, 12.2.4, SQL, PL/SQL, Reports 6i, XML Reports, OAF, Discoverer Reports, Workflow Builder, Unix Shell Scripting, PVCS, Putty, WinSCP.