PROFESSIONAL SUMMARY:

• Confidential has more than seventeen years of experience in the IT industry.
• He has extensive experience as an Oracle Applications techno - functional consultant, involved in implementing Oracle CRM and ERP Applications.
• Expertise in analysis, design and implementation of Oracle eBusiness Suite R12/R11i ( Oracle Financials (AR, AP, CM and GL), Oracle Purchasing (Procure to Pay Process), Order Management (Order to Cash Process), Oracle Property Management, CRM Foundation, Telesales, Teleservice, Interaction Center Scripting, Oracle Advanced Pricing, Oracle Inventory, AOL, System Administrator. He has experience in translating business requirements into functional and technical design documents/specifications.
• Has worked on developing & customization of Forms(6i/10g), Reports (6i/10g), Interfaces, APIs, Discoverer/GL Wand/BI Publisher Reports, Shell Scripts and job scheduling tool APPWORX and has strong programming experience in creating Procedures, Functions, Triggers, Packages and other database objects using SQL, PL/SQL and Forms/Report customizations and knowledge of customizing a page in OA Framework.
• A self-motivated Team Leader / Member with excellent inter-personal, presentation and technical documentation skills with abilities to perform under stress.

FUNCTIONAL EXPERTISE:

• Supply Chain and Distribution: Order Management, Oracle Advanced Pricing, Oracle Inventory
• Oracle Financials: Oracle Payables, Oracle Receivables, General Ledger, Cash Management and Oracle Fixed Assets
• Procurement: Oracle Purchasing
• Administration: Application Object Library, System Administration
• CRM: CRM Foundation, Telesales, Teleservices, Interaction Center Scripting (R11i/R12), TCA
• Real Estate Management: Oracle Property Management
• Business Intelligence: Oracle BI Publisher (formerly named as XML Publisher), GL Wand (Excel4Apps)

TECHNICAL EXPERTISE:

• Experience in Technical Specification Design, Development, Unit Testing, System Integration or Application Interfaces, Migration, Data Conversion, UAT, Production Implementation, Support and maintenance.
• Experience in the preparation of AIM documentations.
• Very well conversant with all aspects of Application Object Library (AOL) development standards, APIs and System administrations of Oracle applications
• Technical Expertise in Interfaces (Inbound/Outbound), Workflows, Forms, Reports and UNIX programming.
• Extensively worked on Trading Community Architecture.
• Experience in Writing stored procedures and database triggers using PL/SQL and expertise in fine-tuning SQL queries and PL/SQL packages.
• Oracle Apex Reports.
• Knowledge of OA Framework.

Software/Tools:  Oracle OA Framework, Oracle Developer Suite 10g, SQL*Plus, PL/SQL, SQL*Loader, TOAD, Workflow, Oracle BI Discoverer 10g, GL Wand (Excel4Apps), JDeveloper, UC4 Application Manager (APPWORX), Oracle Apex

Programming:  Oracle Developer Suite, PL/SQL, UNIX and JAVA

RDBMS:  Oracle 7x, 8, 8i, 9i and 10g

Operating Systems:  Sun UNIX, Windows 2000, Windows NT, Linux

PROFESSIONAL EXPERIENCE:

Oracle ERP Senior Programmer

Atlanta, GA

Functional Responsibilities:

• Oracle Applications Upgrade and Ledger Consolidation
• Retrofit & test the custom objects as per the changes in R12.
• Test integrity of customizations to ensure no overrides due to R12 upgrade
• Worked with ePrentise for merging multiple ledgers into a single ledger
• Creation of project plans, task/work breakdown and estimation.
• Studying the requirements, performing risk analysis and mapping the business processes
• Analyzing the gaps and recommending the necessary customizations.
• As a Team Leader coordinated with the technical team to review development plans, design documents, explain technical approaches and clarify user requirements.
• Conducting code, design and unit test reviews.
• Post-live support.

Technical Responsibilities:

• Development and Implementation of various Interfaces of Financial data from legacy system (AP invoices, Journals, Payment Reconciliations).
• Development and Implementation of Interfaces for Sales Order Life Cycle from legacy system (EDI, Pocket Advantage and Web-portal).
• Order Management Workflow customizations.
• Integration with Cisco routing System (Finesse) with Oracle Teleservice (Contact Center Form) for Customer Inbound Calls.
• Oracle Apex report development.
• Designed and implemented various interfaces/Conversion for Channel Revenue (Supplier Details and Claims).
• Designed, development and support of reports, interfaces, forms (Forms 12i)
• SOA (Service Bus) integration to external systems for inbound/outbound data transfers.

Environment: Oracle Applications 12i, Oracle BI Discoverer 11g, GL Wand Reports, Oracle Workflow, Oracle 12i, SQL, PL/SQL, Oracle 12i Forms, TOAD, Sun Solaris

Oracle APPS Techno-Functional Consultant

 Atlanta, GA

Functional Responsibilities:

• Oracle Applications Upgrade - 11i to R12
• Partner with Oracle support team, business team, and other vendor parties to identify and remedy key issues introduced by upgrade
• Coordinate with DBA team for applying various patches.
• Retrofit & test the custom objects as per the changes in R12.
• Test integrity of customizations to ensure no overrides due to R12 upgrade
• Setup of Fixed Assets module
• As a Team Leader coordinated with the technical team to review development plans, design documents, explain technical approaches and clarify user requirements.
• Requirement reviews with the project customer to understand the needs and propose solutions.
• Involved in the definition of Roles & Responsibilities matrix as per the SOX compliance.
• Involved in setting of security by creating data access sets and security rules.
• Creation of project plans, task/work breakdown and estimation.
• Mentoring and training up junior and new staff.
• Arranging & chairing weekly team meetings, focusing on targets & achievements
• Project tracking using Microsoft Project Plan (MPP) and critical chain graphs.
• Mentoring and technically guiding team members.
• Conducting code, design and unit test reviews.
• Status reporting and being the single point of contact for the customer.
• Studying the requirements, performing risk analysis and mapping the business processes
• Analyzing the gaps and recommending the necessary customizations.
• Setting up Oracle General Ledger Module (Define Accounting Flexfield, GL Code Combinations, Journal Sources, Categories, Auto-Posting, Auto-Reverse options, define Set of Books, setup Suspense Accounts)
• Setup of Revaluation (Rates, Revalue Account Balances, Average Balances )
• Data fix for duplicate in GL Balances and GL Daily Balances
• Configured Journal Approval Process workflow.
• Archive & Purge of Journals
• Preparing BR100 - Setup Documents
• Preparing MD50 - Data Conversion documents
• Designing and implementing various tests, debugging the software and providing post-live support.

Technical Responsibilities:

• Development and Implementation of Conversion of Financial data from legacy system i.e., Accounting Structure, GL Balances, Journal Data into Oracle General Ledger using Open Interface features of GL Module
• Developed scripts for GL data conversion
• Involved in defining Menus, Responsibilities as per the Roles & responsibilities matrix.
• Designed, development and support of reports, interfaces, forms (Forms 12i)
• Installation and setup of Application Manager (APPWORX) scheduling tool.
• Installation and setup of T-Recs (Total Reconciliation System) and integration of Journal Data from Oracle General Ledger
• Setup and maintain Oracle Hyperion (Smartview),

Environment: Oracle Applications 12i, Oracle BI Discoverer 11g, Oracle Workflow, Oracle 9i, SQL, PL/SQL, Oracle 12i Forms, TOAD, Sun Solaris

Oracle APPS Techno-Functional Consultant

Atlanta, GA

Functional Responsibilities:

• Participating in Oracle Application upgrades from 11.5. 10 to 12 i.
• Participated in Oracle Application upgrades from 11.5.9 to 11.5.10.2
• As a Team Leader coordinated with the technical team to review development plans, design documents, explain technical approaches and clarify user requirements.
• Requirement reviews with the project customer to understand the needs and propose solutions.
• Studying the requirements, performing risk analysis and mapping the business processes
• Involved in identifying Role & Responsibilities and defining the Responsibilities based on that
• Analyzing the gaps and recommending the necessary customizations.
• Designing and implementing various tests, debugging the software and providing post-live support.
• Setup Daily Business Intelligence for Oracle Financials and Customer Support
• Developed the various user manuals.

Technical Responsibilities:

• Completed configuration and setup of Customer Support, Telesales, and CRM Foundation modules in Development. Test and Production Instances.
• Setup new bank account and branches
• Modified the Positive Pay report accordingly to the Bank format.
• Modified the ACH file format according to the new bank format.
• Enabled the Audit trail for various custom/standard tables
• Designed custom process for importing Journals.
• Development of custom interface for loading assets information using Mass Additions Process.
• Customization of Dashboards/KPI’s and Report for Daily Business Intelligence
• Used FNDLOAD for lookup Types and Responsibilities templates migration from one instances to other instances.
• Supported all Go-live activities and Post-production troubleshooting.
• Analysis of customizations and enhancements: evaluate design, quality, stability and maintainability of custom code developed to fill gaps between standard Oracle Applications functionality and business requirements.
• Analysing and developing of data conversion/Interface script.
• Development of Various Reports using Report Builder 6i and 10g.
• Designed various Business Areas using Discoverer Administrator
• Developed various reports using Oracle Discoverer 10g
• Development of database objects (packages, procedures, triggers, views, etc.) to provide custom functionality within the ERP and CRM
• Supplier Merge and Purge Process to clean up the duplicate suppliers in Oracle Purchasing
• Customization of Payment Mass Approval and Payables export process in Oracle Property Management
• Integrated Custom Address Validation(Clean Address) with Oracle Applications,
• Created Business Intelligence reports using Oracle BI Publisher ((formerly named as XML Publisher)
• Worked on customization of Metadata Administration (Spreadtable).
• Designed custom workflow.
• Defined value sets, flex field, concurrent programs, report sets, request sets.
• Registered custom forms, reports and PL/SQL Procedures, Triggers and Packages.
• Extended the functionality of Special Menus.
• Performance tuning for PL/SQL programs to reduce the runtime and to increase efficiency.
• Involved with the testing team in testing the various Forms, Reports and Interfaces developed by other groups.

Environment: Oracle Applications 12i/11.5.10.2, Oracle BI Publisher, Oracle BI Discoverer 10g, Workflow, Oracle 9i, SQL, PL/SQL, Oracle 6i/10g (Forms & Reports), TOAD, UNIX (IBM AIX)

Confidential

Oracle APPS Techno-Functional Consultant

Responsibilities as a functional consultant:

• Managed a team for Technical developers for implementation of Oracle Customer Relationship Management.
• Studying the requirements, performing risk analysis and mapping the business processes
• Analyzing the gaps and recommending the necessary customizations.
• Configuring the modules, designing forms/reports and add-ons and coordinating with the technical team to monitor development and implementation progress.
• Designing and implementing various tests, debugging the software and providing post-live support.
• Monitoring & controlling resources and ensuring completion within schedule.
• Facilitating end-user training and developing the various user manuals.

Responsibilities as a Technical consultant:

• Completed configuration and setup of CRM Foundation, Custom Support, Telesales and Oracle Inventory modules in Development. Test and Production Instances.
• Analysis of customizations and enhancements: evaluate design, quality, stability and maintainability of custom code developed to fill gaps between standard Oracle Applications functionality and business requirements.
• Integrated CRM with BSCS, this integration enables Customer Creation and Contract Activations from CRM.
• Integrated CRM with Payment Gateway to enable Credit Card Processing from Oracle CRM
• Developed Broadcasting Tool for Call Center Administrators for publishing messages to Call Center Agents.

Environment: Oracle Applications 11.5.9, Workflow, Oracle 9i, SQL, PL/SQL, SQL Loader, Oracle 6i (Forms & Reports), Shell Scripting, TOAD, UNIX (Tru 64)