SUMMARY:

• 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.
• 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.
• Worked as a Solution designer, played a critical role 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.

TECHNICAL SKILLS:

Database: Oracle 11g, 10g, 9i

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

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland

Senior Technical Lead

Responsibilities:-

• Played a critical role 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 Developed and Implemented the Interfaces Monitor dashboard( Confidential ) 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 Confidential 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.

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

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 Confidential 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, Bloomfield, CT

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

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 theRCV 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, PA

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.

TECHNICAL CONSULTANT

Modules: - Oracle AP, Oracle GL, Oracle PO

Responsibilities:

• Understand the business requirement and coding according to the specifications.
• Actively involved in Accepting Tickets and solving them.
• Developing packages, procedures and SQL scripts for small enhancements, Break Fixes.
• Making small changes in existing set up as per requirement.
• User acceptance Testing Support.
• Actively involved in solving the abends.
• Contacting to respective Batch operations to solve the issues or to rerun the jobs which are abended.
• Involved in raising Change Request and Prodex Request.
• Developed Interface Tables using SQL Loader Program and validations performed by PL/SQL scripts and developed custom Reports using Report builder.
• Developed Form personalization to prevent modification of FSG reports sent to legacy system
• Enabling the Audit process on Key tables.
• Created Periodic and Event Alerts for new user creation, User Amendments, Concurrent Manager Status
• We have developed custom code for creating a WEB ADI for uploading the Invoices
• Developed Automation process to submit the Requests after receiving the file from legacy systems.

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