PROFESSIONAL SUMMARY:

• Over 8 years of experience as a Certified Oracle E - Business Essentials R12 in requirement analysis, design, development and implementation as a Techno-Functional Consultant for various product versions of Oracle Applications e-Business Suite ranging from 11.0.3, 11.5.9, 11.5.10.2 to 12.1.3.
• Experience in diverse roles across my career as Implementation Specialist, Techno-Functional Consultant, Production Support Executive and Oracle Developer.
• Expertise in Oracle Applications 11i and R12 Supply Chain modules Order Management (OM), Inventory (INV), Accounts Receivables (AR), Warehouse Management System (WMS), Mobile Supply Chain (MSC), Purchasing (PO), Accounts Payable(AP), General Ledger (GL), Shipping (WSH), Cash Management (CE), Fixed Assets (FA), I procurement, I expenses.
• Experience working in designing and developing custom solutions using application interfaces and APIs.
• Experience working in data conversions between different versions of Oracle EBS and migration from legacy applications.
• Project Manager for several IT projects, including an OracleEBSproject.
• Experienced in loading data into Oracle Database using Data Loader.
• Extensive experience with the Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Design validation & setup of GL, AP, AR, INV, OM, and Advanced Pricing PO modules.
• Possess strong knowledge of Supply Chain Management modules of Oracle applications, with concentration in Quoting, OM, and Advance Pricing.
• Knowledgeable in Oracle table structures, schemas, APIs and open interfaces.
• Proficient in SQL to pull up the data and use these data for migration and configuration purposes.
• Demonstrated knowledge of Oracle R12 EBS Financial Models: GL, FA, AP, AR, CE, OM and PO.
• Proficient in SQL tuning and optimization of queries.
• Good experience in Oracle BI Publisher reporting.
• Extensive knowledge on PL/SQL components like Procedures, Functions, Cursors, Packages, Triggers and other features such as VARRAYS, Nested Tables, Index by tables, Bulk Collections, Database Triggers using features like Cursors, Collections, Exception Handling and Bulk binding.
• Experience with oracle and other utilities like PLSQL developer, SQL Navigator and Toad.
• Hands on experience working on UNIX platforms in developing shell scripts.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL Plus.
• Experience in working with Oracle Utilities like UTL FILE Package and Interfaces.
• Proficient in preparing documents based on Oracle AIM and Oracle OUM standards.
• Have strong experience in leading the team and handling critical production issues.

FUNCTIONAL SKILLS

Application Version: Oracle Applications e-Business Suite 11.0.3, 11.5.9, 11.5.10.2, 12.1.3Applications

SCM: Order Management (OM), Inventory (INV), Purchasing (PO), Advanced Pricing, Warehouse Management (WMS), Mobile Supply Chain

CRM: Install Base

Finance: General Ledger (GL), Account Receivables (AR), Account Payables (AP), Cash Management (CE), Fixed Assets (FA), Cash Management (CE)TECHNICAL SKILLS

Oracle Apps Modules: Financials (GL, AP, AR, FA, PO, OM), CE, INV, FS, PJB, PJC, PJR

Databases: Oracle 11g, 10g, Oracle 9i, Oracle 8i

Documentation: AIM and OUM Methodologies

Third Party Tools: Vertex and Pitney Bowes

Code Control Tools: CVS, TFS, Clear Case, KINTANA, SVN

Languages: Oracle SQL, PL/SQL, UNIX Shell Scripting, Oracle Forms, Macro

Agile Tool: Rally Enterprise Edition

Reporting: Oracle XML/BI reports

Office Tools: MS Office, MS Project

Development Tools: SQL*Plus, SQL Developer, PLSQL Developer, SQL Navigator, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Princeton NJ

Oracle Project Manager & Tech Lead

Responsibilities

• To interact with users and to gather inputs on various business requirements and problems.
• To propose appropriate solutions and to develop solutions for business requirements and to fix/apply corrective actions for the issues as stated by the users.
• Analysis of the Database, various components in the Application and Third Party applications. Capturing the Analysis in BP010 and BP040.
• Capture the requirement in BR030 document and coming up with BP080 (Future Process Model / Future state architecture).
• Preparing BR100 document to capture the setups in future state application and preparing MD060 and MD070 design documents & Oracle R12 EBS Financial Models.
• Participated in business planning and requirements review of Oracle Financials, Discrete Manufacturing, Order Management / Shipping and Inventory (Warehouse - WMS), Advanced Supply Chain Planning, Customer Relationship Management, Logistics Management and Enterprise Asset Management solutions.
• Delegate and track task assigned to offshore team using Rally (Agile tool) and assist them with the day to day activity.
• Integrating third party application with Oracle Application.
• Migrating Data to new environment.
• To help business by supporting in-house ‘Horizon’ application and ease up their day-to-day activities.
• To process transactions, post, verify and correct journal entries and generate financial statements at the end of each month and assist with period closure
• Create and manage data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.
• Create PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables.
• Work towards SQL Tuning and applying hints for faster and better performance of the SQL queries.
• Prepare functional, user documents, process flow diagrams and flow charts.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Prepare test plans and perform unit testing, CRP and SIT testing and assist users during UAT.
• Interacted daily with business users and functional resource to gather requirements for dashboard.
• Hands-on experience in scheduling batch jobs in UNIX.
• Create deployment scripts to deploy changes in production environment.
• Monitoring and submitting custom UNIX jobs for the business users during UAT.
• Create and maintain deployment scripts to deploy changes in production environment.

Environment, Tools & Software’s

Confidential, Princeton, NJ

Oracle Project Manager

Responsibilities

• To interact with users and to gather inputs on various business requirements and problems.
• To propose appropriate solutions and to develop solutions for business requirements and to fix/apply corrective actions for the issues as stated by the users.
• Worked as a Functional Analyst in Implementations, Upgrade and Post Production Support of Oracle EBS in various industries.
• Coordinate with offshore in the development and support for interfaces for data sync up
• Create and maintain BR100 application setup document for all licensed applications in R12.1.3
• Design and develop VB macros for data-sync up activities and other reporting results
• Create and manage data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.
• Create PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables.
• Work towards database optimization for better application performance
• Prepare functional AN100 and technical DS140 documents and also other user documents and process flow diagrams as per OUM Methodology
• Create IM90 deployment scripts to deploy changes in production environment.

Environment, Tools & Software’sOracle 11g, Oracle Applications E-Business Suite R12, Warehouse Management System (WMS), TOAD, Oracle Forms and Reports, PL/SQL, UNIX

Confidential, Schaumburg, IL

Oracle Techno Functional Consultant

Responsibilities

• To interact with key stakeholders for gathering requirements specific to data migration and to propose appropriate conversion strategies.
• To design technical solutions including code and documentation (CV40 and CV60) for the conversion components
• Migrate solutions across instances and version management using ‘KINTANA’ and ‘Clear Case’
• Generate statistics and other reports post conversion on data accuracy and quality
• Create and manage data base objects such as Database Links, Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.
• Create PL/SQL packages using public APIs, procedures, functions applying the business logic to load the data to relevant staging and interface tables.
• Work towards database optimization for faster conversion and smaller downtime windows during migration
• Prepare functional and technical design documents for data conversion.
• Create deployment scripts to deploy changes in production environment.
• To interact with key stakeholders for gathering requirements specific to design and development of OAF Pages
• To design technical solutions including code and documentation (AN100 and DS140) for the development componentsAdditional Responsibilities:
• Create Oracle Applications Framework web pages using J-Developer IDE.
• Work towards database optimization for faster conversion and smaller downtime windows during migration
• Prepare functional and technical design documents for data conversion.
• Create deployment scripts to deploy changes in production environment.

Environment, Tools & Software’sOracle 11g, Oracle Applications E-Business Suite R12.1.3, R11.5.10.2 ‘J-Developer’, WMS, PL/SQL, UNIX

Confidential

Oracle Applications Technical Lead

Responsibilities

• To interact with key stakeholders for gathering requirements specific to design and development of integrating Oracle EBS with other industry applications via a messaging broker
• Perform map and gap analysis to integrate the enterprise applications together in sync with the day-to-day business processes
• To design technical solutions including code and documentation (MD050 and MD070) for various development components by Oracle AIM Methodology
• To prepare TE20, TE50 test scripts, execute tests, monitor and fix defects.
• Develop PL/SQL code using Interfaces and APIs for various business requirements.
• Prepare CV40, CV60 migration documents and develop code for migration of data from Oracle E-Business Suite 11.5.9 to 11.5.10.2
• Design and Development of APEX 4.x applications and integrating them with Apps.
• Prepare BR100 documents, maintain versions and migrate code across database instances.
• Design TE20, TE50 test scripts, execute tests, monitor and fix defects.
• Reporting and other managerial activities.
• Incident Management - To identify, analyze, and correct issues reported by customers, vendors and the manufacturing units across geographies and assist them in handling orders through various stages, managing inventories, creating invoices, generating advance shipment notice (ASN) and support them during period end activities.
• Change Management - To perform updating and deletion of the data in production instance, after carefully tested in support or test instance.
• Problem Management - To provide permanent fixes for the re-occurring issues and bugs in existing processes or code.
• Monitor queues and incident tickets, assigning it to the right teams and to perform hand over for persistent issues.
• Develop PL/SQL code using Interfaces and APIs for fixes and new business requirements.
• Work towards database optimization for better application performance
• Develop the Data Loader scripts to load data into the staging tables from the flat files.
• Design and develop VB macros for data-sync up activities and other reporting results
• To propose appropriate solutions and to develop solutions for business requirements and to fix/apply corrective actions for the issues as stated by the users.
• Create PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables

Environment, Tools & Software’s