PROFESSIONAL SUMMARY:

• Over 11 + Years of IT Professional experience in Oracle Applications full Implementation cycles, Up gradations, Post production and Production support projects as a Techno Functional consultant with functional study in developing interfaces, conversion, migration, enhancement, upgrade, workflows, reports and forms in Oracle Projects (Project Costing, Project Billing, OTL.), Financials (AP,AR, FA,GL,CM, iExp, EB - Tax ) and Manufacturing (PO, INV,OM, BOM, WIP, iProc, iStore ) modules.
• A strong team player with good written, verbal communications and leadership skill. Experienced in working in a global environment with cross-functional teams and out-sourcing service providers
• Extensive experience in Oracle Applications versions R12, 11i (11.5.10 &11.0.3) 10.7 in Financials, manufacturing, Projects, Planning, Distribution, in Multi-Org, TCA Architecture.
• Technical side expertise in Customizations, Enhancements, Reports, Forms, Interfaces, Workflows (RICEW) and conversion that includes Application Software Development, Mapping, Data cleaning, ETL (Extract, Transform, Loading), Testing, Documentation, Production Deployment and Production Maintenance and support.
• Functional side experience in Preliminary Requirement Study (white papers) for customer requirement definition, Study business logic for decision support design, understanding physical system, Business process Analysis, Designing for process flow modeling, System Analysis, Configurations, Test plans, Test scripts, Testing and Documentation for customizations RICE to manage development of functional and technical specifications for Oracle EBS related objects. It covers customization, gap analysis, upgrading and helps to analyze in order to come out with resolution.
• Experience working independently and/or with team in Technical development and Functionality study for customizations along with internal users (business users and decision makers) and external / non-oracle third parties. Involved with Discussions and resolving problems with DBA, Data hub, Data warehouse and UNIX administrators, presenting to Quality control department, production deployments, troubleshooting queries, data, identifying production issues and resolving them. Open in handling new modules or requirements in Oracle Application. Coordinating different local and overseas teams.
• Extensive Upgrade Experience in Finance Modules, Project Accounting (Project costing & Project Billing), Procure to Pay and Order to Cash.
• Have very strong experience in requirements gathering, functional gap analysis, application design, configuration, module setup, writing guides, test scripts, testing, and production support.
• Exposure to areas of Software Development Life Cycle pertaining to Software System Analysis, Design, Data Migration, Data Conversion, System Integration, Testing, and Implementation.
• Experienced in writing documents at various stages using AIM methodology.
• Experienced in jDeveloper (OAF) pages Development, Customization and Personalization.
• Experienced in WEB ADI Integrators, layouts Development and Customizations.
• Experienced in XML, BI Publisher Reports Development and update existing reports. Experience in developing Workflows.
• Developed interfaces using Oracle, PL/SQL, SQL*PLUS, SQL*Loader, APIs, UTL FILE, Perl scripts, UNIX shell scripts. Developed & Modified reports using Oracle report Builder, BI Publisher, XML and Discoverer.
• Experience of oracle database concepts, modeling and database objects that includes stored packages, procedures, functions, views and triggers along with instances / production deployment scripts, performance tuning, analyzing index and quality assurance.
• Worked in both Technical development and Functional study in Oracle Application EBS (Oracle apps) for US local and Global.
• Experienced in facilitating business process workshops, creating or documenting business requirements, business process flows, functional specifications, use cases, and test plans. Self-motivated with an ability to work with minimal direction in a complex and dynamic environment to drive consensus amongst diverse business stakeholders.
• Prepared test cases and Business flows, reconciliation methods, prepared documents like BP010 ( Define Business and Process)
• Experience with oracle on demand, multi-language, multi-table, multi-currency and accounting entries functionality
• Worked on AOL setups for concurrent programs, request group, users, menus, flex fields, Personalization and configurations required for customization through System administration.
• Experienced in Logging and Monitoring Service Requests through Oracle Meta link.
• Collaborated well with project management, business analysts, business users and department management teams. Participate in PMO activities for Project Planning, Resource Management, Status Reporting, Issue/Risk Management etc.
• Experienced in requirement gathering, system analysis & design, data analysis, design review, process flow analysis, gap analysis, implementation, upgrade, reporting, project management, configuration, support, maintenance, testing, development, customization, patch application, documentation, building interfaces or extensions, conversion, system administration, data fixing, bug tracking, month-end-closing, problem-solving, and other consulting functional and technical activities.
• Participated in code review for custom coding scripts and to maintain standards in order to provide synchronization for maintenance benefit.
• Presented to the special QA Quality control department including Oracle DBA and UNIX administrators, the blueprint deliverables for changes made for sensitive data security purpose.
• Full understanding of the Oracle Financials Accounting Hub (FAH) and Oracle Financial Services Accounting Hub (FSAH).
• Ability to learn new things quickly and to work under the pressure.
• Ability to work with different IT solution to find out suitable products that suits business needs.
• Strong interpersonal skills, ability to interact with people at all levels good communication and presentation skills.

TECHNICAL SKILLS:

Oracle Applications: ORACLE Applications EBS (E-Business suite) R12, 11i (11.5.10/11.5.9/11.5.5/11.5.4 ),10.7.2Projects (PA) Project Costing, Project Billing, OTL (Oracle Time and Labor)

Finance: Payables (AP), Receivables (AR), Fixed Asset(FA),General Ledger(GL), Cash Management, Enterprise Asset Management, Oracle Alerts and Service Contacts.

Manufacturing: Purchasing (PO), Order Management (OM), Inventory (INV), iProcurement, iStore, BOM, WIP.

Order to Cash (O2C /OTC), Procure to Pay (P2P / PTP): System Administration (SA), Application Object Library (AOL) and AIM Methodology

Front-end/Oracle Tools: Oracle JDeveloper (OAF), Forms 6i/4.5, Reports 6i/2.5, COBOL, Taviz, Business Objects, Informatica, PerlBI Publisher Reports, XML Reports, OBIEE, Workflow Builder, Web ADI.

Tools: AUTOSYS, Toad, SQL Developer, Microsoft Power Point, Microsoft Project 2000, ftp, Putty, Win SCP, Intranet tickets, Remedy ticketing system, Desktop ftp, Kintana, SVN.

Oracle Utilities: PL/SQL, SQL*PLUS, SQL*LOADER, UTL FILE

Operating Systems/Environments: Unix, Windows 95 / NT / 2000, Unix

Languages: C, Data Structures using C, COBOL, Unix, Linux

RDBMS: Oracle 11g/10g (10.2.0.2) /9i (11.5.9/11.5.10 ) /9.x

AIM Documentation: Worked extensively in documenting Functional {MD.050}, Technical {MD.070}, Conversion {CV.040}, Gap Analysis {BR.010}, Test Scripts {TE.040}, Installation instructions {MD.120} documents using AIM methodology. Knowledge of Current Business baseline {RD.020}, Upgrade {BR.100}, Future Process Model {BP.080}, Create Application extension modules {MD.110} documents

Web Technologies: HTML, Java Script, Core Java, JDBC, JSP, EJB, XML.

Other Skills: Testing Tools.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle Application 12i

Team Member/Lead (Techno Functional Consultant/Functional Consultant)

Responsibilities:

• Preparation of PL/SQL scripts for the RICE Components.
• Developed RICEW Components as per requirements
• Coordinating with client in analyzing incidents and determining their impact on the system under consideration.
• Doing required application set ups in different environments.
• Wrote UAT test scripts; Performed Dev and QE unit testing up to SLA closings; Hosted UAT planning meeting, Reviewed QE test scripts and test results, Reviewed and compiled UAT test results; Obtained UAT sign-off documents.
• Developed & customized Oracle Forms using Oracle Forms builder & JDeveloper. (OAF).
• Developed Interface scripts for integrating FAH with Non EBS Systems.
• Developed & Customized WEB ADI Integrators, Layouts and Documents.
• Developed & Modified Workflows based on the client requirements.
• Form Personalization’s in Oracle Forms
• OAF Extensions, customizations and Personalization’s
• Strong interpersonal skills, ability to interact with people at all levels good communication and presentation skills
• Developing the Reports by using the BI Publisher, XML
• Converting Existing RDF reports in to XML/BI Publisher Reports.
• Worked On API’s.
• Provide proper Handshake between the Applications
• Designing, Testing and implementing upgrades, enhancement and setups
• Analysis of client supplied documents.
• Requirement Analysis for enhancements/changes and doing the enhancement/changes.
• Controlling the Version control of the objects and migrating the code to the different staging and Production servers
• Preparing customer requirement documents and development requirement documents
• Maintain project related documents
• Collect various metrics on process and product quality.
• Provide Month-end, Quarter end and year end support.
• Performing Data fix and code fix.
• Providing Production support to end users.
• Providing weekly status to the clients on the application related issues.
• Resolving issues raised by customers.

ERP Tools/ Languages: PL/SQL, TOAD, Oracle Forms, reports, JDeveloper(OAF)BI Publisher. Web ADI, Workflow Builder.

Modules: AP, AR, GL, PA, FA, PO, INV, OM, BOM, WIP, iProc, Cash Management, iStore.

Confidential, Webster, New York

Environment: Oracle Application 12i,11i (11.5.10.2)

Techno Functional Consultant/Functional Consultant

Responsibilities:

• Preparation of PL/SQL scripts for the RICE Components.
• Coordinating with client in analyzing the incidents and determining their impact on the system under consideration.
• Doing required application set ups in different environments
• Analysis of client supplied documents.
• Requirement Analysis for enhancements/changes and doing the enhancement/changes.
• Performing Data fix and code fix.
• Controlling the Version control of the objects and migrating the code to the different staging and Production servers
• Preparing customer requirement documents and development requirement documents
• Maintain project related documents
• Collect various metrics on process and product quality.
• Providing Production support to end users.
• Passing the developed code to Production through Moveit tool
• Provide proper Handshake between the Applications
• Reviewed other functional design docs and participated in Integration Design Walk-thrus for supplier integration interface
• Designing, Testing and implementing upgrades, enhancement and setups
• Developed & Modified Oracle Forms using Oracle Forms builder & JDeveloper.(OAF).
• Worked on VO, EO, CO Extensions and Personalization’s In OAF Pages.
• Strong interpersonal skills, ability to interact with people at all levels good communication and presentation skills
• Developed Reports by using the BI Publisher, XML
• Converting Existing RDF reports in to XML/BI Publisher Reports.
• Worked On API’s.

ERP Tools/ Languages: PO,INV,AP,AR,GL,OM,PA,BOM,WIP,FA and Cash Management.

Confidential, Phoenix, Arizona

Environment: Oracle Application 12i,11i (11.5.10.2),&10.7

Team Lead / Team Member (Techno Functional /Functional)

Responsibilities:

• Projects and Tasks Conversion using AMG in Projects Module.
• Preparation of PL/SQL scripts for Developing RICE Components.
• Coordinating with client in analyzing the incidents and determining their impact on the system under consideration.
• Doing required application set ups in different environments
• Analysis of client supplied documents.
• Requirement Analysis for enhancements/changes and doing the enhancement/changes.
• Performing Data fix and code fix.
• Controlling the Version control of the objects and migrating the code to the different staging and Production servers
• Preparing customer requirement documents and development requirement documents
• Maintain project related documents
• Resolving issues raised by customers.
• Collect various metrics on process and product quality.
• Raising and Handling tickets for issues related to Confidential through BMC ticketing tool.
• Providing weekly status to the clients on the application related issues.
• Passing the developed code to Production through Assent Tool
• Provide proper Handshake between the Applications
• Designing, Testing and implementing upgrades, enhancement and setups
• Developed Informatica Reports.
• Developing the Reports by using the BI Publisher, XML
• Working On API’s
• Worked on VO, EO, CO Extensions and Personalization’s In OAF Pages.

ERP Tools/ Languages: PL/SQL, TOAD, Oracle Forms, OAF, Oracle reports, BI Publisher and Workflow Builder.

Modules: Project Accounting, AP, AR, GL, FA, PO, INV OM, BOM, WIP Cash management, iprocurement and HRMS

Confidential, Phoenix, Arizona

Environment: Oracle Application 11i (11.5.10)

Techno Functional Member

Responsibilities:

• Preparation of PL/SQL scripts for the Application
• Developing the New reports based on the Business Requirements.
• Coordinating with Onsite resources in analyzing the incidents and determining their impact on the system under consideration
• Analysis of client supplied documents.
• Requirement Analysis for enhancements/changes and doing the enhancement/changes.
• Performing Data fix and code fix
• Preparing customer requirement documents and development requirement documents
• Resolving issues raised by customers.
• Collect various metrics on process and product quality.
• Providing weekly status to the clients on the application related issues.
• Provide proper Handshake between the Applications

ERP Tools/ Languages: Oracle 9i, PL/SQL, TOAD, Oracle Forms and Reports

Modules Involved: Project Accounting, AP, AR, GLPO, INV, OM.

Confidential

Team Member

Responsibilities:

• Technical Consultant.
• Preparation of technical specifications from the functional specifications received from the functional team
• Designing Forms and Reports.
• Designing reports that populates the data pertaining to the users

ERP Tools/ Languages: PL/SQL, TOAD, Oracle Forms & Reports.

Modules: PA,AP, AR, GL,PO and HRMS.