PROFESSIONAL SUMMARY:

• Experience as an Oracle E - Business Suite consultant in various process lifecycles such as requirement analysis, design, development, implementation, testing and support
• Experience as an Oracle E-Business Suite consultant in diverse Industries such as Telecommunications, Travel and Manufacturing
• Experience in for various product versions of EBS - 11.0.3, 11.5.9, 11.5.10.2 and 12.1.3
• Expertise in various modules - Purchasing (PO), Accounts Payable(AP), General Ledger (GL), Order Management (OM), Accounts Receivables (AR), Shipping (WSH), Inventory (INV) and Warehouse Management System (WMS and MSCA)
• Good understanding of all technical aspects of enterprise applications such as Workflows, PL/SQL Packages, Reports, Interfaces and Extensions, Data Loaders, SQL*Loaders and UNIX shell scripts
• Hands on experience developing and testing custom interfaces and extensions using PL/SQL
• Experience in data conversions between different versions of Oracle EBS and migration from legacy applications
• Proficient in process standards such as Oracle Application Implementation Methodology (AIM) and Oracle Unified Methodology (OUM)
• Ability to work independently with minimal supervision
• Self-motivated self-starter dat can initiate ideas
• Strong experience leading the team, handling critical and challenging production issues and take pride in solving them
• Inspiring team player with excellent interpersonal and communication skills

FUNCTIONAL SKILLS

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

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

CRM Install Base: Finance General Ledger (GL), Account Receivables (AR), Cash Management, Account Payables (AP)

Oracle Apps Modules: Financials (GL, AP, AR), OM, INV, PO, WMS, MSCA

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

Documentation: Oracle AIM and OUM Methodologies

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

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

Reporting: Oracle XML/BI Publisher reports

Office Tools: MS Office, MS Project

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

PROFESSIONAL EXPERIENCE:

Confidential, Attleboro, MA

Oracle Functional Consultant

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.
• Capture the requirement in RD010 document and coming up with BP080 (Future Process Model / Future state architecture).
• Participate in business planning and requirements review of Oracle Financials, Discrete Manufacturing, Order Management / Shipping and Inventory (Warehouse - WMS), Advanced Supply Chain Planning.
• Delegate and track task assigned to team using Rally (Agile tool) and assist them with the day to day activity.
• Integrate third party applications with Oracle Applications using core Oracle Service Oriented Architecture (SOA)
• Migrating data from legacy systems to current environment
• To process transactions and rectify transactional errors 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: Oracle 11g, Oracle Applications E-Business Suite R12, Oracle Forms and Reports, PL/SQL, TOAD, UNIX, Rally Agile Development software, Vertex Q series, Pitney Bowes Spectrum 10.

Confidential, Chicago, IL

Oracle Techno-Functional Consultant

Responsibilities

• Interact with users and to gather inputs on various business requirements and problems.
• Propose appropriate solutions and to develop solutions for business requirements and to fix/apply corrective actions for the issues as stated by the users
• Coordinate with IT groups and external vendors to ensure TEMPeffective application services and reliability of all production applications
• Maintain logs of all issues and ensure resolutions according to defined processes
• Prepare functional AN100 and technical DS140 documents and also other user documents and process flow diagrams as per OUM Methodology
• 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
• Create IM90 deployment scripts to deploy changes in production environment

Environment, Tools & Software’s Oracle 11g, Oracle Applications E-Business Suite R12, TOAD, Oracle Forms and Reports, PL/SQL, UNIX

Confidential, Schaumburg, IL

Oracle Techno Functional Consultant

Responsibilities

• Interact with key stakeholders for gathering requirements specific to data migration and to propose appropriate conversion strategies
• 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

Environment, Tools & Software’s: