SUMMARY

• Almost 8 Years of experience as Senior Techno - Functional Consultant in Oracle Applications (E-Business Suite) implementation, enhancements, customizations, migration, interfaces and conversions.
• Expertise in Technical and Functional aspects of Oracle applications R 12/11.5.10/11.5.9 Financials and CRM Service. Financial modules, which include Financial Accounting Hub (FAH) General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR) and Fixed Assets (FA). Oracle CRM Service modules which include Field Service, Teleservice, Install Base (IB) and Service Contracts (OKC and OKS).
• Very good exposure to modules like Trading Community Architecture (TCA), Inventory (INV), Order Management (OM), Enterprise Asset Management (EAM) and Oracle Quotes.
• Well experienced in Reports, Interfaces, Conversions, Extensions and Workflow (RICEW), Implementation and Support in various Oracle Apps modules.
• Involved in implementing versions/upgrades of Oracle Applications 11i and Oracle Applications R12 for Oracle Business.
• Extensive experience in Java Web services.
• Expertise in using Oracle PL/SQL, SQL, BI/XML Publisher, APIs, Oracle 11g/10g/9i/8i under Windows/UNIX/LINUX environments.
• Extensive experience in technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suite of Applications.
• Import and Export utility, SQL* Loader.
• Extensive experience in writing Oracle backend objects like: Database Triggers, Stored Procedures, functions and Packages using PL/SQL.
• Creation of Install scripts to migrate objects between Instances.
• Creation of concurrent programs to execute requests viz.; reports, stored procedure, shell script.
• Strong knowledge of order to cash (O2C) and procure to pay (P2P) business flows.
• Expertise in using third party software’s like TOAD, SQL Developer, PUTTY and WINSCP.
• Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Proficiency in understanding clients needs and generate, modify existing data in Oracle Applications according to the requirements and specifications.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.

TECHNICAL SKILLS

ERP: Oracle applications 11i/R12 (Financials, AP, AR, GL, OM, INV, Service Contracts, Install Base, Field Service, Teleservice, Oracle Quotes, AOL.

Languages: SQL, PL/SQL, XML.

Databases: Oracle 8i/9i/10g.

Web Tools: HTML.

Tools: Oracle Workflow, TOAD, SQL Developer, Microsoft Project and Visio.

Operating Systems: UNIX & Linux, Windows98/XP and Windows NT.

PROFESSIONAL EXPERIENCE

Oracle Applications Techno-Functional Consultant

Confidential, Houston, TX

Responsibilities:

• Identifying deltas between 11i and R12 and remediating the CEMLIs wherever required.
• Review functional requirement and prepare MD070 technical design documents for the new requirements
• Testing and migrating remediated object to all R12 instances.
• Validating standard functionality and custom CEMLI’s after every cycle of upgrade process.
• Providing technical support during SIT and UAT sessions.
• Coordinating with the offshore technical team and make sure they have all required details.

Oracle Applications Techno-Functional Consultant

Confidential, Ewing, NJ

Responsibilities:

• As FAH Techno-Functional Consultant, part of requirement gathering sessions with Functional team and providing technical feedback.
• Mapping requirement with the standard Oracle FAH functionality.
• Responsible for providing technical solutions to various customizations supporting multiple external source systems like GRE, TOEFL, PRAXIS etc.
• Defining businesses process flow and give presentations to the business and conduct POC's.
• Review functional specs and Preparing technical design documents for all Customizations and Interfaces.
• Possess experience in ORACLE EBS Applications (CRM & Distribution).
• Walk with the business to get approvals on Technical design documents.
• Design and developing Java webservices to integrate external source systems with Oracle FAH and FAH to PeopleSoft.
• Developing custom integrator for WebADI and generate required templates for manual journal import process.
• Develop custom programs to process source transactions and create events in Oracle FAH for accounting.
• Design and develop custom journal load process to transfer accounted summarized journal entries from Oracle FAH to PeopleSoft through webservice
• Design and develop custom drilldown process from PeopleSoft to Oracle FAH to review detail journal entries and transactions.
• Providing technical and functional support during CRP testing.
• Involved on go live activities, worked on Production issues and gave 24 x 7 production support which also included training the end users on performed validations and reports.
• Extensively used Oracle CRM Service modules which include Field Service, Teleservice, Install Base (IB)

Oracle Applications Techno-Functional Consultant

Confidential, Bloomfield, CT

Responsibilities:

• Responsible for providing technical solutions to various customizations supporting multiple legacy subledgers.
• Defining businesses process flow and give presentations to the business and conduct POC’s.
• Analyzing business needs and ensure that solution meets customer objectives without compromising on the quality.
• Providing high performance solutions for automated custom flows to process external legacy subledger transactions and transfer to R12 GL through Financial Accounting Hub.
• Responsible for reviewing requirements and functional specs, and preparing Technical Design documents for various customizations and interfaces in AR, AP and GL.
• Designed and developed complex interfaces between legacy subledgers and R12 GL via FAH, which includes, loading, validating, transforming and creating events.
• Coordinating with offshore technical team and monitoring development tasks.
• Designed complex solution of flipping Journal Source while transferring Journals to GL through FAH using GL Import User Hook.
• Designed and developed various inbound and outbound interfaces related to AP and AR.
• Created custom sources for Fixed Assets SLA and used them to modify the SLA rules
• Delivering required XML Publisher reports in FAH
• As part of the production support team, responsible for taking care issues raised by business users after post golive.
• Resolving issues, raised by business users, within SLA and coordinating with the business users for testing, after code migrations as per release calendar.
• Performing root cause analysis of the issues and avoid the occurrences of similar issues in future.
• Continuously strive on support process improvements for smooth functioning of the system and increase customer satisfaction.
• Coordinating with offshore development team and provide the required details.
• Reviewing and testing code delivered by offshore development team before releasing to the customers.
• Make all documents are up to date by updating them whenever there is change/enhancement to the objects.

Environment: Oracle Applications R12 (FAH, AR, AP, GL), BI Publisher, SQL LDR, TOAD, Stored Procedures, Windows 2000, UNIX, AOL

Oracle Applications Techno Functional Consultant

Confidential, Exeter, PA

Responsibilities:

• Reviewing requirements and providing feedback
• Suggesting feasible and efficient solutions for all customizations, integrations and conversions.
• Providing Technical solutions to new enhancements and preparing Technical design documents.
• Developed highly complex custom programs for Service to Quoting integration.
• Developed highly complex programs for custom Warranty Creation process using Inventory Item Cross References.
• Developed various enhancements to transfer additional data from Charges to OM through User Hooks.
• Created various complex form personalizations to cater customer’s requirements.
• Preparing test scripts for CRP’s
• Providing Technical and Functional support to the users during CRP sessions.
• Coordinating with offshore technical team on technical deliverables.
• Performing root cause analysis of the issues and avoid the occurrences of similar issues in future.
• Updating technical documents in case of enhancement requests raised by business users after post go live and make sure all the documentation is up to date.
• Preparing technical design documents, MD070’s, for all customizations and integrations

Environment: Oracle Apps 11i, AOL, ORACLE 9i/10g, PL/SQL, Oracle Workflow, Toad, XML/BI Publisher, UNIX.

Oracle Applications Technical Consultant

Confidential, Sunnyvale, CA

Responsibilities:

• Designed, Developed and Supported various Rice components related to Oracle Quotes and Configurator.
• Developed various complex customizations to integrate R12 Configurator and Quotes.
• Attending various design sessions with functional and boundary teams to understand the requirements
• Reviewing functional requirements and preparing Technical design documents for various CEMLI’s.
• Managing offshore and onsite technical team and make sure technical objects delivered on time with proper unit testing.
• Developed highly performance intensive Service Contracts conversion program, which is capable of converting almost 5M Service Contracts with almost 60M lines.
• Developed complex custom PL/SQL integration programs to ADD, EDIT and Update configurations in Oracle Quotes.
• Managing defects during post production support and assigning defects to appropriate resources both Onsite and Offshore.
• Generating reports on open defects and submitting it to the management on daily basis.
• Making sure all technical documents are up to date.

Environment: Oracle Apps R12 (CZ, ASO), Oracle database 10g/11g, Oracle Applications 11i & R12, Toad, Red hat Linux, SQL, PL/SQL

Oracle Applications Technical Consultant

Confidential, Washington DC

Responsibilities:

• Designed and developed high performance solutions in integrating external subledgers into Oracle FAH.
• Reviewing functional requirements and providing technical LOE for various technical components.
• Attending various sessions with DBA’s to come up with optimal performance criteria for all the processes.
• Developed complex and fully Automated End-to-End FAH process flow, which includes 13 processes, to Extract, Load, Validate, Process, Summarize and Transfer 84M journal entries within 12 Hour SLA.
• Possess experience in ORACLE Applications (CRM).
• Prepare technical documents for all custom objects.
• Created webservice on a custom PL/SQL package using Integrated SOA Gateway.
• Handled assigned defects and provided required technical support during CRP’s
• Making sure all the technical documents are up to date.

Environment: Oracle Applications R12 (Financial Accounting Hub) Oracle 10g, XML Publisher, TOAD, Integrated SOA Gateway, Windows XP, UNIX.

Oracle Developer

Confidential, Santa Clara, CA

Responsibilities:

• Developed and supported various RICE Components in Oracle Service Contracts and Field Service modules.
• Closely worked with offshore technical team in designing and developing custom solutions for EVS (Entitlement Verification System), which includes Web Services, Form Customizations and Custom Integrations.
• Developed customizations for Planned Downtime Solution in Services modules.
• Have done performance intensive Form customizations.
• Developed various inbound and outbound interface in Field Service and Service Contracts.
• Part of the technical team, developed Contracts consolidation program to save 70% of Service Contracts storage.
• Provided support and handled change requests after every release.

Environment: Oracle Application 11i (Service Contracts, Install Base, Field Service, OM, AR, TCA), BPEL, Oracle 9i, PL/SQL, Toad and UNIX