SUMMARY:

• Having around 11 years of experience in technical development of Oracle Applications E - Business Suite Release 11i, R12 versions.
• Implementations and exposure to implementation methodologies such as Oracle AIM.
• Having knowledge on, Discoverer Reports Admin, XML publisher Reports, Workflows.
• Worked on Oracle Applications R12 implementation using FAH (Financial Accounting Hub).
• Having good functional knowledge on Procure to Pay (PTP) modules.
• Team Player with the ability of interpersonal relationship and good Communication skills.
• Flexible and versatile to adapt new environments and work on different projects.
• Extensive experience in Oracle EBS development AIM methodology from thorough review of MD050s with functional walkthroughs to understand functional requirements, then analyze, design and development of code components in RICEW preparation of detailed technical design documents MD070 with flow charts followed by unit test scripts and migration documentation MD120.
• Strong Acumen in Technical Development in developing RICEW Components (Forms, Reports, Interfaces, Conversions, Extensions) in the domain of Oracle EBS using SQL, PL/SQL, Developer 6i/10i(Reports), Workflow Builder, Oracle Alerts, Oracle BI Publisher, XML Publisher, Forms Personalization’s.
• Two full lifecycle implementations experience (R12/11i) of PTP (Procure to Pay ), OPS cycles going through Development (DEV), User Acceptance Test (UAT) and Production, User, go-live and post go-live Support in complex Multi-Org Environment.
• Experience in support services and testing the applications and interfaces.
• Good understanding and exposure to Oracle Apps Data Model, Application Object library components (KFF, DFF, Value Sets etc.).
• Strong interpersonal skills with ability to interact with people across all levels with very good team leading capabilities.
• Experience in conducting s for fresher’s in the team on interfaces, Oracle Pl/SQL, XML Reports, Interfaces, Conversions.
• Worked as a Solution designer, played a critical Confidential in making enterprise systems and programs are envisioned, designed, developed and implemented across the enterprise to meet business needs.
• Involved in every phase of the project lifecycle from intake through delivery and will be considered one of the leadership team members that have primary responsibility that a solution is well engineered, operable, maintainable, delivered on schedule, aligns to enterprise vision and actually provides the anticipated business value.
• Have been recognized and ed multiple times for delivering complex extensions, interfaces and conversions with good quality and within time lines.

TECHNICAL SKILLS:

Database: Oracle 11g.

ERP Modules: PO, AP, GL, FAH, AR

Languages: SQL, PL SQL, Java, C, Unix scripting, XML

Front End Tools: Oracle Developer Reports 10g, Workflow Builder 2.6.3.5

Reporting Tools: Oracle Reports6i/10g, Oracle BI Publisher

Other Tools: SQL* Loader, PLSQL Dev 5.1.3, TOAD, SQL Developer, Peregrine Service Centre 6.1.1, HP Quality Centre 9.2, Citrix, Winscp, HP Kintana, Clear Case

PROFESSIONAL EXPERIENCE:

Confidential

Senior Technical Lead

Responsibilities:

• Played a critical Confidential in making enterprise systems and programs are envisioned, designed, developed and implemented across the enterprise to meet business needs.
• Involved in every phase of the project lifecycle from intake through delivery and will be considered one of the leadership team members that have primary responsibility that a solution is well engineered, operable, maintainable, delivered on schedule.
• Design and Implemented on integrating the T& E Concur system with oracle applications to reimburse the employee expenses.
• Design and Developed and Implemented the Interfaces Monitor dashboard(IMD) to track the file movement for the Procure To Pay interfaces.
• Involved in design and Implemented the Oracle iSupplier integrating with other Eaton web portals.
• Developed and implemented the iSupplier user accounts Conversion from the Portal application
• Understanding the business requirement and designed solution to meet the requirements.
• Reviewed the Technical design documents and suggest the changes if requires.
• Reviewed the TUT results.
• Involve in meetings with vendors while integrating with external systems like AP analytics First Strike, Spendware house, Concur etc..,
• Coordinating with AMEX team on validating the remittance files validation.
• Conduct meeting with other internal application which are integrated with Oracle apps system, analyze impacts and provide solutions for the same.
• Analyzing the new change requests and do impact analyses.
• Involved in the CAB meeting to explain the impact analysis for the change requests and get approval to implement the same.
• Conducted sessions with business users on understanding the newly implemented system.
• Understanding the business requirement and converted into Functional Design documents(MD050).
• Conducted Technical Hand off meeting and explained the business requirements in detailed to technical teams.
• Review the developed code and helping team on doing unit testing by creating the test scenarios.
• Helping business team on UAT issues and on creating Business test scenarios.

Confidential

Technical Lead Consultant

Responsibilities:

• As part of Project Unify R12 developed Inbound interface to load the employee expenses from concur to Oracle Payables through Inbound Interface and then into base tables to make payments.
• Developed SQL*Loader file to load data from flat files to oracle Custom table.
• Developed inbound interface for Oracle Payables from different sources.
• Developed outbound interface to send the Payment information to Concur to update the payment information of employees.
• Developed packages to validate the payment information as part of outbound interface to send the Payment information in various formats to AMEX for vary regions
• Prepared MD070 based on the MD050, Test plans, and code movement documents as per the client standards.
• Migrating the developed code through clear case and Kintana tools.
• Raised CR to Oracle for Production Movement using client templates.
• Unit Testing, Bug fixes and performance Issues

Environment: Oracle R12, Windows 7, Oracle 11g, PLSQL Developer 10, SQL*Loader, Workflow Builder, Oracle Report, Procure to Pay.

Confidential

Technical Lead Consultant

Responsibilities:

• Worked on design and development of FAH conversion and Interfaces to extract data from ERP to FAH base tables
• Developed Inbound interface to load the GL Transactions from different sources into R12 Oracle General Ledger through FAH, interface table and then into base tables.
• Developed SQL*Loader file to load data from flat files to oracle Custom table.
• Developed PLSQL packages for EBS validations, FAH validations and then insert data into XLA interface table to create events for the transactions.
• Developed inbound interface for Oracle Payables from different sources.
• Developed outbound interface to send data to different sources like Webster, CES applications
• Preparing MD070 based on the MD050, Test plans, and code movement documents.
• Reviewed MD070, UAT plans, Code documents as per the Client standards.

Environment: Oracle APPS R12, Windows XP, Oracle 11g, Toad, SQL*Loader, Procure to Pay.

Confidential

Technical Consultant

Responsibilities:

• Reviews TGF’s current technical code to assist TGF to identify any potential risk areas in the existing component for bug fixing
• Identifies and evaluates TGF technical requirements; Design and code for enhancements /customization. Testing, integration of developed components. UAT support to Oracle applications software configurations and software tools;
• Establish TGF needs for release management and change management
• Develop appropriate release management and change management procedures
• Adhere to the TGF SLA’s in resolving the incidents raised, respond in time to the client queries and provide resolution
• Customized the Standard Format Payment Process request, Payment Instruction Register XML Reports, Cash Requirement RDF Reports
• Developed Custom Packages, Procedures for Break Fixes and SQL queries for client Adhoc queries.
• Customized the Standard Invoice Approval workflow using the Budget Holder Approval Hierarchy.

Environment: Oracle APPS R12, Windows XP, Oracle 10g, PLSQL Developer, Procure to Pay.

Confidential

Network Services/Support

Responsibilities:

• Created a Staging tables to insert the valid invoices data created by iSupplier.
• Developed PL/SQL packages to pick the valid Invoices created from iSupplier portal and insert the data into the RCV HEADERS INTERFACE,RCV TRANSACTIONS INTERFACE tables then populated them into the main tables by running the Receiving Transaction Processor Program.

Environment: Oracle APPS R12, Windows XP, Oracle 10g, PLSQL Developer, SQL Loader, Procure to Pay Modules.

Confidential

Technical Consultant

Responsibilities:

• Conversion of Invoices Data implemented from Legacy System to Oracle Apps
• Used SQL Loader to dump the invoices data provided in the form of flat files from the legacy system into normalized staging tables.
• Developed PL/SQL packages to pre-validate and clean up the data in the staging tables and insert the data into the AP INVOICES INTERFACE, AP INVOICE LINES INTERFACE tables then populated them into the main tables by running the Payables open Interface Program

Environment: Oracle APPS 11i, Windows XP, Oracle 10g, PLSQL Developer, SQL Loader, Procure to Pay Modules.